By using this website, you agree to our Terms of Use (click here)
Hi All,
I built a Generic Inquiry that gives me proper results (tested with the records in the DB).
After exporting that as a report and adding same fields as the GI, I'm getting the following error
The correlation name TableName is specified multiple times in a FROM clause
I think it's worth mentioning that the GI links custom tables made in the database to the default ones.
What could cause the issue?
Thanks,
Mike
Can you take a screenshot of the table relationships in the build schema area?
Maybe you should be using an Alais on each different join to CSSRemittanceDetail