如何从三个表中获取唯一位置,位置在三个表中应该是唯一的?
table1 : location = delhi // location is column name in all three tables <br>
table2 : location = delhi
table3 : location = delhi
结果:
delhi
试试这个:
select * from table1 INNER JOIN table2 on table1.location = table2.location
INNER JOIN table3 on table2.location = table3.location;
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句