如何选择记录形式多表，其中每列的表数都不相同 [英] how to select record form many table where no of column each table not same

问题描述

亲爱的所有人
如何选择记录表在不同的表中没有.

dear All
how to select record form different table where no. of column are different each table.

推荐答案

有两种方法可以实现查询..！
首先使用JOINS
其次是使用UNION ALL

只是尝试获取有关此信息...！
问候..
Dnyanesh

there are two ways where u can implemented your queary..!
first by using JOINS
and second by using UNION ALL

just try to get information abt this...!
Regards..
Dnyanesh

列数并不重要，除非您是指WHERE子句中使用的列.您可以创建一个将表和列组合在一起的视图，或者形成一个公共集合，然后从中进行选择.或者，您可以使用SELECT *，尽管这是最少的选择.

The number of columns doesn''t really matter, unless you mean the columns used in the WHERE clause. You could create a view that combines the tables and columns, or forms a common set, then do you select from there. Or you could use SELECT *, though this would be the least choice.

这篇关于如何选择记录形式多表，其中每列的表数都不相同的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！