(select
Anderson, d as id, b.n ame as name
The from aTable a, bTable b
Where Anderson, d=b.i d) as c
Left the join dTable d on
C.i d=d.i d and d.i d='123'



Why error ah, can't write it, a great god help see the along while also didn't see the error

CodePudding user response:

and people

CodePudding user response:

The original poster write all the statements, look not to come out this sentence,

CodePudding user response:

Write their own little select * from the statements are not complete

CodePudding user response:

(select

 
Anderson, d as id, b.n ame as name 
The from aTable a, bTable b 
Where Anderson, d=b.i d) as c - here, the table alias cannot use the as, remove the as 
Left the join dTable d on 
C.i d=d.i d and d.i d='123'