二张表,左连接查询,但右边表里的数据我只要一部,左连接语句怎么写??
全部查询情况:
select * from a left join b where a.id=b.id;b表我只要其中一部:
select * from a left jion (select * from b where b.name like 'aa' as c) where a.id=c.id报错说 as附近有语法错误怎么解决???
全部查询情况:
select * from a left join b where a.id=b.id;b表我只要其中一部:
select * from a left jion (select * from b where b.name like 'aa' as c) where a.id=c.id报错说 as附近有语法错误怎么解决???
select * from a left join b on (a.id=b.id and b.name like 'aa')
select
*
from
a
left join
b
on
a.id=b.id
where
b.name like 'aa'
错误二: select * from a left join
(select * from b where b.name like 'aa') as c on a.id=c.id