G
Guest
I am using an union query to combine 2 queries. My SQL is this so far:
SELECT [shipdate], [CustomerRefFullName]
FROM [qrysalesorder]
UNION ALL SELECT [shipdate], [CustomerRefFullName]
from [qryinvoiceline];
I am using this with an ODBC program that is pulling info from our
accounting software.
The error I'm getting is this:
"ODBC--CALL FAILED
[ODBC] Expected Lexical Element not found: <keyword> (#11015)
I tried combining the original tables, and it gives me the same error
message. It seems that it is a problem with the union query and the ODBC
program as all of my queries work fine, and it doesn't matter which fields I
try--I still get the same error. Also, if I delete 1 half of my Union Query
SQL, it works fine. Anybody know anything about getting union
queries to work with an ODBC program? Thanks!
SELECT [shipdate], [CustomerRefFullName]
FROM [qrysalesorder]
UNION ALL SELECT [shipdate], [CustomerRefFullName]
from [qryinvoiceline];
I am using this with an ODBC program that is pulling info from our
accounting software.
The error I'm getting is this:
"ODBC--CALL FAILED
[ODBC] Expected Lexical Element not found: <keyword> (#11015)
I tried combining the original tables, and it gives me the same error
message. It seems that it is a problem with the union query and the ODBC
program as all of my queries work fine, and it doesn't matter which fields I
try--I still get the same error. Also, if I delete 1 half of my Union Query
SQL, it works fine. Anybody know anything about getting union
queries to work with an ODBC program? Thanks!