如何在sql中显示多个表中的所有列？

need sql query with (sql server or oracle or any database language)

需要sql查询(sql server或oracle或任何数据库语言)

5 个解决方案

#1

SQL request select * from table1, table2.. Here * will give you all columns in each table.

SQL请求select * from table1,table2 ..这里*将为您提供每个表中的所有列。

#2

Try OUTER JOIN query, it will show all data Ref
Combine multi join queries to get more effect!

尝试OUTER JOIN查询,它会显示所有数据Ref Combine多连接查询以获得更多效果!

#3

select * from table1, table2,..., tableN

Returns cartesian join of tables

返回表的笛卡尔连接

#4

Not sure what you are asking, as the your question is too vague, try asking the exact thing you want, by telling number of tables, column names etc. But I can guide you in the right directions. You can use table JOINS in SQL, if they have some common values in tables. FOR example:

不确定你在问什么,因为你的问题太模糊了,试着通过告诉桌子数量,列名等来问你想要的确切内容。但是我可以指导你正确的方向。如果表中有一些常用值,则可以在SQL中使用表JOINS。例如:

SELECT a.ID, a.Name, b.ID, b.Name from tbl_student a JOIN tbl_dept b ON a.D_ID = b.D_ID;

#5

Using SELECT * to start your query will select all the columns from all the tables that you are selecting from. Have a read about it here.

使用SELECT *启动查询将选择您选择的所有表中的所有列。在这里阅读一下。

If you want SELECT from multiple tables then you will need to use JOIN, dont use the old style joins i.e. FROM TABLE1, TABLE2, TABLE3 they nasty and went out of date 20 years ago. There's a handy post here that will show you the different types of JOIN operators.

如果你想从多个表中选择SELECT,那么你将需要使用JOIN,不要使用旧的样式连接,即FROM TABLE1,TABLE2,TABLE3,它们令人讨厌并且在20年前已经过时了。这里有一个方便的帖子,它将向您展示不同类型的JOIN运算符。

Your query will look something like this:

您的查询将如下所示:

SELECT
    *
FROM Table1 T1
INNER JOIN Table2 T1 ON T1.Coulmn1 = T2.Coulmn1

#1