标准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