标准SQL!select A.Name , B.ID , B.Date , B.GZRW , B.SFWC from B left outer join A on B.id = A.idorselect A.Name , B.ID , B.Date , B.GZRW , B.SFWC from A right outer join B on B.id = A.id
--修改一下 --标准SQL! select A.Name , B.ID , B.Date , B.GZRW , B.SFWC from B left outer join A on B.id = A.id where B.GZRW IS NOT NULL --or select A.Name , B.ID , B.Date , B.GZRW , B.SFWC from A right outer join B on B.id = A.id where B.GZRW IS NOT NULL
--修改一下 --不太标准,但应该通用。 Select A.NAME, B.Date , B.GZRW , B.SFWC FROM A,B WHERE A.ID=B.ID AND B.GZRW IS NOT NULL Union Select B.* FROM B WHERE GZRW IS NULL
--搞错了。 --改一下!要求A.NAME字段类型与B.ID相同。 Select A.NAME, B.Date , B.GZRW , B.SFWC FROM A,B WHERE A.ID=B.ID AND B.GZRW IS NOT NULL Union Select B.ID, B.Date , B.GZRW , B.SFWC FROM B WHERE B.ID IS NULL
--标准SQL!
select A.Name , B.ID , B.Date , B.GZRW , B.SFWC from B left outer join A on B.id = A.id
where
B.GZRW IS NOT NULL
--or
select A.Name , B.ID , B.Date , B.GZRW , B.SFWC from A right outer join B on B.id = A.id
where
B.GZRW IS NOT NULL
--不太标准,但应该通用。
Select A.NAME, B.Date , B.GZRW , B.SFWC FROM A,B WHERE A.ID=B.ID AND B.GZRW IS NOT NULL Union Select B.* FROM B WHERE GZRW IS NULL
--改一下!要求A.NAME字段类型与B.ID相同。
Select A.NAME, B.Date , B.GZRW , B.SFWC FROM A,B WHERE A.ID=B.ID AND B.GZRW IS NOT NULL Union Select B.ID, B.Date , B.GZRW , B.SFWC FROM B WHERE B.ID IS NULL