还有问下,
select A.* , B.value from A left join B on A.id = B.id ,这样B表没有数据的时候右边是空的.
但是
select A.* , B.value from A left join B on A.id = B.id where B.name = 'ss'; 如果原先右边是空的话,直接整行数据都没了.怎么在右表没有这个数据或者不满足b.name= 'ss'右边显示空白,有数据且满足b.name= 'ss'显示正确的b.value[/quote]
ok,解决了.
select A.* , B.value from A left join (select * from B1 where B1.name = 'ss' )B on A.id = B.id ;
还有问下,
select A.* , B.value from A left join B on A.id = B.id ,这样B表没有数据的时候右边是空的.
但是
select A.* , B.value from A left join B on A.id = B.id where B.name = 'ss'; 如果原先右边是空的话,直接整行数据都没了.怎么在右表没有这个数据或者不满足b.name= 'ss'右边显示空白,有数据且满足b.name= 'ss'显示正确的b.value