I am writing a custom report, using an odbc connection to a "SQL" database. (I say that because it's more of a pseudo SQL database.) Anyway I'm connected fine and as long as I only pull data from one table.

I have my tables linked throgh the database expert as enforce both and left outer join.

The problem that I ran into is that the sql query looks like this

SELECT "table1"."ID", "table2"."ID" FROM "table1" "table1" LEFT OUTER JOIN "table2" "table2" ON "table1"."ID" = "table2"."ID" WHERE "table1"."ID" = 2

The issue with this query is that my table are duplicated in the FROM secetion and my database is not handling the query properly because of it. I have restarted building the query from the ground up and gotten the same result, I have deleted the header fields to see if that would make a difference. Then to make sure it was the query causing my heartache, I ran the query through mysql on my server without the double tables in the join and it behaved properly.

So my question becomes, why does crystal double the tables, and how do I get rid of the double entry?

I will test it out and I will get back to youw. Thanks.