如果四个表加入SQL SERVER [英] SQL SERVER joining if four tables

问题描述

我想加入4个表。所以，我正在编写以下查询..

 选择 
 DonorRegistrationInformation。*，
 DonorOfficeUse。*，
 DonorSTransactionAmount。*，
 DonorMTransactionAmount。* 
 <跨度类= 代码-keyword> FROM  DonorRegistrationInformation 
  INNER   JOIN  DonorOfficeUse  on  DonorRegistrationInformation.DONNO = DonorOfficeUse.DONNO 
  inner   join  DonorSTransactionAmount <跨度类= 代码关键字>上 DonorRegistrationInformation.DONNO = DonorSTransaction.DONNO 
 <跨度类= 代码关键字>内 <跨度类=代码 - 关键字 >加入 DonorMTransactionAmount <跨度类= 代码关键字>上 DonorRegistrationInformation.DONNO = DonorMTransactionAmount.DONNO 

但是得到了以下错误

消息 4104 ，等级 16 ，状态 1 ，行 1  
多部分标识符  DonorSTransaction.DONNO可以不绑定。

请如何解决。

解决方案

你在哪里包括表 DonorSTransaction 在中或加入？看起来你只是忘了在查询中包含这个表。



祝你好运！

上DonorRegistrationInformation.DONNO = DonorSTransaction.DONNO

内部联接DonorSTransactionAmount



什么是DonorSTransaction？更正



i认为它应该是



内部加入DonorSTRactionInmount on DonorRegistrationInformation.DONNO = DonorSTransactionAmount.DONNO

查询中没有名为DonorSTransaction的表格，您加入了

内部联接DonorSTransactionAmount on DonorRegistrationInformation.DONNO = DonorSTransaction.DONNO 

请检查一次....

I want to join 4 tables.So, I am writing the following query..

SELECT 
DonorRegistrationInformation.*,
DonorOfficeUse.*,
DonorSTransactionAmount.*,
DonorMTransactionAmount.* 
FROM DonorRegistrationInformation 
INNER JOIN DonorOfficeUse on DonorRegistrationInformation.DONNO = DonorOfficeUse.DONNO 
inner join DonorSTransactionAmount on DonorRegistrationInformation.DONNO=DonorSTransaction.DONNO
inner join DonorMTransactionAmount on DonorRegistrationInformation.DONNO = DonorMTransactionAmount.DONNO

But Getting the following error

Msg 4104, Level 16, State 1, Line 1
The multi-part identifier "DonorSTransaction.DONNO" could not be bound.

Please How to correct it.

解决方案

Where did you include the table DonorSTransaction in a where or join? Looks like you simply forgot to include this table in the query.

Good luck!

inner join DonorSTransactionAmount on DonorRegistrationInformation.DONNO=DonorSTransaction.DONNO


what is "DonorSTransaction"? correct this

i think it should be

inner join DonorSTransactionAmount on DonorRegistrationInformation.DONNO=DonorSTransactionAmount.DONNO

There is no table called "DonorSTransaction" in the query and you joined with

inner join DonorSTransactionAmount on DonorRegistrationInformation.DONNO=DonorSTransaction.DONNO

Please check it once....

这篇关于如果四个表加入SQL SERVER的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！