Inner Join on Multiple Tables
<p>I'm having difficulties getting an inner join statement to work that is combining a common data element on 4 different tables.</p>

<p>Table 1: TWSchwabPlanSponsor<br>
Table 2: TWSchwabBrokerDealerTPA<br>
Table 3: TWSchwabInvestmentAdvisor<br>
Table 4: TWFidelityDetailByCorrespondent</p>

<p>The common field on all 4 tables is <code>CUSIP</code>. What I'm trying to do is add the purchases from all 4 tables for a specific <code>CUSIP</code> (543917108). This <code>CUSIP</code> is present on all 4 tables. The results should display the <code>Fund Name</code> and the total amount of purchases. </p>

<p>The attached statement will run but the results do not match what I get when manually adding the raw data.</p>

<pre><code>SELECT        
    MARSLite.dbo.TWSchwabPlanSponsor.[Fund Name], 
    MARSLite.dbo.TWFidelityDetailByCorrespondent.[Purchases ($)]
     + MARSLite.dbo.TWSchwabBrokerDealerTPA.Purchases 
     + MARSLite.dbo.TWSchwabInvestmentAdvisor.Purchases
     + MARSLite.dbo.TWSchwabPlanSponsor.Purchases AS 'Purchases'

FROM MARSLite.dbo.TWFidelityDetailByCorrespondent 
INNER JOIN MARSLite.dbo.TWSchwabBrokerDealerTPA 
    ON MARSLite.dbo.TWFidelityDetailByCorrespondent.CUSIP =
       MARSLite.dbo.TWSchwabBrokerDealerTPA.CUSIP 
INNER JOIN MARSLite.dbo.TWSchwabInvestmentAdvisor 
    ON MARSLite.dbo.TWSchwabBrokerDealerTPA.CUSIP = 
       MARSLite.dbo.TWSchwabInvestmentAdvisor.CUSIP 
INNER JOIN MARSLite.dbo.TWSchwabPlanSponsor 
    ON MARSLite.dbo.TWSchwabBrokerDealerTPA.CUSIP =
       MARSLite.dbo.TWSchwabPlanSponsor.CUSIP

WHERE (MARSLite.dbo.TWSchwabBrokerDealerTPA.CUSIP = '543917108')

GROUP BY 
    MARSLite.dbo.TWSchwabBrokerDealerTPA.CUSIP, 
    MARSLite.dbo.TWSchwabPlanSponsor.[Fund Name], 
    MARSLite.dbo.TWFidelityDetailByCorrespondent.[Purchases ($)], 
    MARSLite.dbo.TWSchwabBrokerDealerTPA.Purchases, 
    MARSLite.dbo.TWSchwabInvestmentAdvisor.Purchases, 
    MARSLite.dbo.TWSchwabPlanSponsor.Purchases
</code></pre>