表tb1
name B_id
-------------------
A 0
B 0
C 1表tb2
B_id info
------------------
1 abc能否select出以下这样的表??
name B_id info
---------------------
A 0 NULL
B 0 NULL
C 1 abc
name B_id
-------------------
A 0
B 0
C 1表tb2
B_id info
------------------
1 abc能否select出以下这样的表??
name B_id info
---------------------
A 0 NULL
B 0 NULL
C 1 abc
select tb1.name,tb1.B_id,tb2.info from tb1 left join tb2 on tb1.B_id = tb2.B_id