P
PPCO
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)
Any ideas why it might be doing this?
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)
Any ideas why it might be doing this?