联接多个表 [英] join multiple tables
问题描述
大家好,只是一个简单的问题
Hey everyone just a quick question
软件:数据库位于Azure SQL服务器上
Software: Database is on Azure SQL server
是否可以使用单个查询或脚本内部联接多个表,并使用所有表中存在的单个标识符保留所有表中的所有数据并导出到excel?
Is it possible to use a single query or script to inner join multiple tables and keep all the data from all tables using a single identifier present in all the tables and export to excel?
推荐答案
是的,如果我正确理解您的要求,这似乎是非常基本的情况.您正在寻找与此类似的查询:
Yes, this seems to be very basic case if I understood your requirement correctly. You are looking for query similar to this :
select * from table1,table2,table3
where table1.id = table2.id
and table2.id = table3.id;
如果这是您要查找的查询.请告诉我是否有帮助,请详细说明您的要求,以便我进一步为您提供帮助.
If this is the kind of query you are looking for. Please let me know if this helps else please elaborate your requirement so that I can help you further.
致谢
Anurag Goyal
Anurag Goyal
这篇关于联接多个表的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!