T1表 T2表
t1id t1name t2id t2name
1 a 1 a
2 b 3 b
3 c 4 c
我想得到下面的结果
id t1name t2name
1 a a
2 b 0
3 c b
4 0 c
请问怎么语句该怎么写啊 ，谢谢
------解决方案--------------------
- SQL code
SELECT ISNULL(T1.T1ID,T2.T2ID) AS ID,ISNULL(T1.T1NAME,'0') AS T1NAME,ISNULL(T2.T2NAME,'0') AS T2NAMEFROM T1FULL JOIN T2 ON T1.T1ID=T2.T2ID