从互联网上看到多表联合查询的格式为
SELECT a.name,b.address,c.company From user as a JOIN user_address as b ON a.id = b.uid
JOIN user_company AS C ON a.id = c.uid
格式是没问题的吧?!
我看到多表的连接都是第一个表分别和多个表进行连接,上面的例子中 a 连 b 条件是 a的id
等于 b的uid,然后a在内联c条件也a的id等c的uid
那么如果我是这样写不会有问题吧?
SELECT a.name,b.address,c.company From user as a JOIN user_address as b ON a.id = b.uid
JOIN user_company AS C ON b.uid = c.uid
区别在于 on后面的条件不在是第一个表和第三个表了,而是第二个表和第三个表的uid相等,
这样也是正确的吧?
求大神,谢谢