Couldn’t find anything on this topic…
I need to perform a SQL query on a database, inner joining several datatabels. Db connection is working fine, but I’m getting a syntax error when executing the query:
"Execute Query: ERROR [HY000] [Data Direct][ODBC Progress OpenEdge Wire Protocol driver] [OPENEDGE] Syntax error in SQL statement at or about “[dtMain] INNER JOIN [dt1] ON [dt2” (10713)
Query looks like this:
SELECT dt1, dt2, dt3, dt4, dt5, dt6, dt7, dt8, dt9, dt10, dt11,dt12
INNER JOIN dt1 ON dt2 = dt3
INNER JOIN dt4 ON dt5 = dt6
INNER JOIN dt7 ON dt8 = dt9 AND dt10 = dt11
WHERE dt12= ‘123’
Have tried writing the syntax with and without brackets, but still getting the same error.
Think it has to do with the INNER JOIN-part, but have no clue how to solve this…
Hope that someone can help me, thanks!