SQL Server:一个简单的问题

Question

所以我有一个包含以下列的表Transportation：ClientIDAsSeller, ClientIDAsBuyer..

和一个包含列ID (主键)的Client表。我的C#应用程序在Transportation表中获得一个客户端ID和集合。

当我按下execute result是null

什么是问题?我该怎么解决它？

SELECT     
   Clients.Name, Transportation.TransStart, Transportation.TransEnd
FROM         
   Transportation 
INNER JOIN
   Clients ON Transportation.ClientIDAsSeller = Clients.ID 
              AND Transportation.ClientIDAsBuyer = Clients.ID

Answer 1

通过仅执行一次连接，您可能会排除所有可能的结果集。您可能想要执行以下操作：

SELECT
      S.Name as SellerName
      B.Name as BuyerName,
      Transportation.TransStart,
      Transportation.TransEnd
FROM Transportation
INNER JOIN
     Clients S
ON
     Transportation.ClientIDAsSeller = S.ID
INNER JOIN
     Clients B
ON
     Transportation.ClientIDAsBuyer = B.ID