34,590
社区成员
发帖
与我相关
我的任务
分享
a full outer join b ON a.xx=b.xx inner join C on a.xx=c.xx and b.xx=c.xx
SELECT *
FROM a
full outer join b
ON a.xx=b.xx --#1.a和b先产生一个结果集
inner join C
on a.xx=c.xx and b.xx=c.xx --#2.上面的结果集看成一个表,再和C表INNSER JOIN