Question

sql中如何对左连接查询结果进行子查询

我想要的是类似这个的结果，这么写不对吗？ select * from A a ,(select D d left join E e on d.id=e.id ) as c where a.id=c.aa

Answer 1

select a.*,(select D d left join E e on d.id=e.id ) as c from A a ,D d,E e where a.id=c.aa