sql交叉连接查询

Question

我有更多的表想要交叉连接它们，并且我想显示每个表的字段如下：

tb1.filed1 tb1.filed2 tb2.filed1 .....

我该怎么办？我如何选择包含表名称等详细信息的字段。

谢谢....

Answer 1

最简单的方法是使用列别名，就像您给它另一个名称一样：

Select 
   tb1.filed1 as 'tb1.filed1', 
   tb1.filed2 as 'tb1.filed2', ... //continue for all your coumns
From table1 tb1
Inner Join table2 tb2 on [your criteria]

但是，我建议您使用更具描述性的名称。也许像

Select 
  tb1.filed1 as 'RawInitialFiledDate', 
  tb1.filed2 as 'RawReFileDate',
  tb2.filed1 as 'ConfirmedInitialFiledDate', 
  tb2.filed2 as 'ConfirmedReFileDate'
from table1 tb1
Inner join table2 tb2...

Answer 2

使用别名来给出有意义的描述......例如

select 
   tb1.field1 as "Order ID",
   tb1.field2 as "Order Date", 
   tb2.field1 as "Product ID"
   -- ,etc    
 from Orders tb1
 inner join OrderProducts tb2 on 
    tb2.OrderID = tb1.OrderID and
    tb1.OrderID = @OrderID