Using Microsoft Access:

SELECT dbo_RECORDS.CONSTITUENT_ID, dbo_RECORDS.FIRST_NAME, dbo_RECORDS.LAST_NAME, dbo_GiftGLDistribution_1.Amount AS [Original Amount], dbo_GiftGLDistAccount_1.Debit_Number AS Original_Debit, dbo_GiftGLDistAccount_1.Credit_Number AS Original_Credit, dbo_GIFT_1.DTE AS Adjustment_Date, dbo_GiftGLDistribution.Amount AS Adjustment_Amount, dbo_GiftGLDistAccount.Debit_Number AS Adjustment_Debit, dbo_GiftGLDistAccount.Credit_Number AS Adjustment_Credit

FROM (((dbo_RECORDS INNER JOIN dbo_CONSTIT_GIFTS ON dbo_RECORDS.ID = dbo_CONSTIT_GIFTS.CONSTIT_ID) INNER JOIN ((dbo_GIFT INNER JOIN dbo_GiftAdjustment ON dbo_GIFT.ID = dbo_GiftAdjustment.GiftId) INNER JOIN dbo_GIFT AS dbo_GIFT_1 ON dbo_GiftAdjustment.AdjustmentId = dbo_GIFT_1.ID) ON dbo_CONSTIT_GIFTS.GIFT_ID = dbo_GIFT.ID) INNER JOIN (dbo_GiftGLDistribution INNER JOIN dbo_GiftGLDistAccount ON dbo_GiftGLDistribution.Id = dbo_GiftGLDistAccount.GiftGLDistributionId) ON dbo_GIFT_1.ID = dbo_GiftGLDistribution.AdjustmentId) INNER JOIN (dbo_GiftGLDistribution AS dbo_GiftGLDistribution_1 INNER JOIN dbo_GiftGLDistAccount AS dbo_GiftGLDistAccount_1 ON dbo_GiftGLDistribution_1.Id = dbo_GiftGLDistAccount_1.GiftGLDistributionId) ON dbo_GIFT.ID = dbo_GiftGLDistribution_1.AdjustmentId;


Using Microsoft Query Analyzer:

SELECT RECORDS.CONSTITUENT_ID, RECORDS.FIRST_NAME, RECORDS.LAST_NAME, GiftGLDistribution_1.Amount AS [Original Amount], GiftGLDistAccount_1.Debit_Number AS Original_Debit, GiftGLDistAccount_1.Credit_Number AS Original_Credit, GIFT_1.DTE AS Adjustment_Date, GiftGLDistribution.Amount AS Adjustment_Amount, GiftGLDistAccount.Debit_Number AS Adjustment_Debit, GiftGLDistAccount.Credit_Number AS Adjustment_Credit

FROM (((RECORDS INNER JOIN CONSTIT_GIFTS ON RECORDS.ID = CONSTIT_GIFTS.CONSTIT_ID) INNER JOIN ((GIFT INNER JOIN GiftAdjustment ON GIFT.ID = GiftAdjustment.GiftId) INNER JOIN GIFT AS GIFT_1 ON GiftAdjustment.AdjustmentId = GIFT_1.ID) ON CONSTIT_GIFTS.GIFT_ID = GIFT.ID) INNER JOIN (GiftGLDistribution INNER JOIN GiftGLDistAccount ON GiftGLDistribution.Id = GiftGLDistAccount.GiftGLDistributionId) ON GIFT_1.ID = GiftGLDistribution.AdjustmentId) INNER JOIN (GiftGLDistribution AS GiftGLDistribution_1 INNER JOIN GiftGLDistAccount AS GiftGLDistAccount_1 ON GiftGLDistribution_1.Id = GiftGLDistAccount_1.GiftGLDistributionId) ON GIFT.ID = GiftGLDistribution_1.AdjustmentId;

Disclaimer: We provide programming examples for illustration only, without warranty either expressed or implied, including, but not limited to, the implied warranties of merchantability and/or fitness for a particular purpose. This article assumes you are familiar with Structured Query Language and the tools used to create and modify SQL statements and Crystal Reports. Our Customer Support may help explain the functionality of a particular procedure, but we will not modify, or assist you with modifying, these examples to provide additional functionality.