C chenhaobo Unregistered / Unconfirmed GUEST, unregistred user! 2002-08-21 #1 Access 數據庫不支持full outer join嗎?我用(left join) union (right join)來實現外連接功能的,誰有什么好的辦法呢?(30分)<br />求教了
M MikeZ Unregistered / Unconfirmed GUEST, unregistred user! 2002-09-06 #2 只能如此了!不过union适应注意避免重复的部分。 select * from a left join b on a.id = b.id union select * from b left join a on a.id=b.id where isnull(a.id)
只能如此了!不过union适应注意避免重复的部分。 select * from a left join b on a.id = b.id union select * from b left join a on a.id=b.id where isnull(a.id)