sql 怎么把select的结果作为一个表 和其他表联合

Answer 1

select [A].*,[C].* from [A] left join ( select * from [B] ) as [C] on [A].id = [C].id

Answer 2

SELECT * FROM EMP E, (SELECT DEPTNO,DNAME FROM DEPT) T WHERE T.DEPTNO=E.DEPTNO;
以此类推