Skip to Content
0
Aug 03, 2012 at 03:22 PM

Crystal Reports Linking with an OR

47 Views

I need to be able to link two tables with an OR.

SELECT T0.OcrCode, SUM(T1.Debit), SUM(T1.Credit)

FROM OOCR T0

INNER JOIN JDT1 T1 ON T1.ProfitCode = T0.OcrCode OR T1.OcrCode2 = T0.OcrCode OR T1.OcrCode3 = T0.OcrCode

GROUP BY T0.OcrCode

Is there a way to Link two tables with an OR clause?

I know there is a way to add this as a command and link other tables to it, but I prefer to have crystal link the tables so I have the data available in the future if my customer wants changes. So I am looking for another solution than adding a command to the report.