(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'
為啥報錯呀，不能這么寫么 ，求大神幫忙 看了半天了 也沒看出錯
uj5u.com熱心網友回復：
還有人么
uj5u.com熱心網友回復：
樓主把陳述句寫全了，這半句看不出來。uj5u.com熱心網友回復：
自己寫少了select * from ,陳述句都不全uj5u.com熱心網友回復：
(select
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'
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/102097.html
標籤：高級技術
上一篇：oracle的函式轉成mysql