select a.aname,isnull(b.bbb,'无') as bbb from aa a full join bb b on a.aid = b.aid aname bbb -------------------- -------------------- AAA 哈哈 BBB 呵呵 CCC 无 DDD 无 EEE 无(所影响的行数为 5 行)
用full join干嘛?直接left join即可啊。
樓主的語句,稍作修改, 你原來的語句等同於inner join,改為left joinselect a.aname,IsNull(b.bbb, '无') As bbb from aa a left join bb b on a.aid = b.aid
aname bbb
-------------------- --------------------
AAA 哈哈
BBB 呵呵
CCC 无
DDD 无
EEE 无(所影响的行数为 5 行)