(select
a.id as id , b.name as name
from aTable a ,bTable b
where a.id = b.id ) as c
left join dTable d on
c.id = d.id and d.id='123' 为啥报错呀,不能这么写么 ,求大神帮忙 看了半天了 也没看出错
a.id as id , b.name as name
from aTable a ,bTable b
where a.id = b.id ) as c
left join dTable d on
c.id = d.id and d.id='123' 为啥报错呀,不能这么写么 ,求大神帮忙 看了半天了 也没看出错
a.id as id , b.name as name
from aTable a ,bTable b
where a.id = b.id ) as c --这里,这个表别名不能用as,把as去掉
left join dTable d on
c.id = d.id and d.id='123'