Q qiqi0715 Unregistered / Unconfirmed GUEST, unregistred user! 2006-12-02 #1 我有两个数据表 1 A 2 B 3 C 第二个 1 M 3 N 怎样查询可以得到如下 1 A M 2 B 3 C N
E eastweast Unregistered / Unconfirmed GUEST, unregistred user! 2006-12-02 #2 Select A.*,IsNull(B.Field2,'') As Field2 From tablea A Left Join tableb B on A.field1=B.field1 其实就是简单的数据表连接问题。 根据不同的需要使用inner Join ,left Join,right join,full Join
Select A.*,IsNull(B.Field2,'') As Field2 From tablea A Left Join tableb B on A.field1=B.field1 其实就是简单的数据表连接问题。 根据不同的需要使用inner Join ,left Join,right join,full Join
B bbscom Unregistered / Unconfirmed GUEST, unregistred user! 2006-12-02 #3 select a.id,a.str,b.str2 from table1 as a left join table2 as b on a.id=b.id
