怎么实现如下设计 - 调试易

怎么实现如下设计

SELECT * FROM (SELECT plan.id,userName AS buyerName FROM plan LEFT JOIN user ON buyerId=userId) t1 NATURAL JOIN (SELECT plan.id,userName AS operName FROM plan LEFT JOIN user ON operId=userId) t2 NATURAL JOIN (SELECT plan.id,deptName FROM plan NATURAL dept USING(deptId)) t3;

解决方案 »

免费领取超大流量手机卡，每月29元包185G流量+100分钟通话, 中国电信官方发货

不好意思，上面打错了，更正如下：SELECT * FROM (SELECT plan.id,userName AS buyerName FROM plan LEFT JOIN user ON buyerId=userId) t1 NATURAL JOIN (SELECT plan.id,userName AS operName FROM plan LEFT JOIN user ON operId=userId) t2 NATURAL JOIN (SELECT plan.id,deptName FROM plan LEFT JOIN dept USING(deptId)) t3;