I am trying to combine a couple of queries via a union query. Each individual part works, but when I try to run both in the union query, I get the following error:

ODBC--CALL FAILED
[ODBC] Expected Lexical Element not found: <keyword> (#11015)

My SQL is this:

SELECT [shipdate]
FROM [qrysalesorder]

UNION ALL SELECt [shipdate]
from [qryinvoiceline];

All of my tables and queries work, so I don't know why I would get an error with just the Union Query.

I'll also give you my SQL for my queries...

QRYSALESORDER:

SELECT tblSalesOrderLine.ShipDate, tblSalesOrderLine.CustomerRefFullName, tblSalesOrderLine.ShipAddressCity, tblSalesOrderLine.PONumber, tblSalesOrderLine.SalesOrderLineItemRefFullName, tblSalesOrderLine.SalesOrderLineQuantity, tblSalesOrderLine.SalesOrderLineDesc, tblSalesOrderLine.TemplateRefFullName, tblSalesOrderLine.IsFullyInvoiced, tblSalesOrderLine.IsManuallyClosed
FROM tblSalesOrderLine
WHERE (((tblSalesOrderLine.CustomerRefFullName)<>"LDI") AND ((tblSalesOrderLine.SalesOrderLineItemRefFullName) Is Not Null) AND ((tblSalesOrderLine.TemplateRefFullName) Like "PP Work Sales Order") AND ((tblSalesOrderLine.IsFullyInvoiced)=No) AND ((tblSalesOrderLine.IsManuallyClosed)=No));

And for QRYINVOICELINE:

SELECT tblInvoiceLine.ShipDate, tblInvoiceLine.CustomerRefFullName, tblInvoiceLine.ShipAddressCity, tblInvoiceLine.PONumber, tblInvoiceLine.InvoiceLineItemRefFullName, tblInvoiceLine.InvoiceLineQuantity, tblInvoiceLine.InvoiceLineDesc, tblInvoiceLine.TemplateRefFullName
FROM tblInvoiceLine
GROUP BY tblInvoiceLine.ShipDate, tblInvoiceLine.CustomerRefFullName, tblInvoiceLine.ShipAddressCity, tblInvoiceLine.PONumber, tblInvoiceLine.InvoiceLineItemRefFullName, tblInvoiceLine.InvoiceLineQuantity, tblInvoiceLine.InvoiceLineDesc, tblInvoiceLine.TemplateRefFullName
HAVING (((tblInvoiceLine.ShipDate)>#3/1/2006#) AND ((tblInvoiceLine.CustomerRefFullName)<>"LDI") AND ((tblInvoiceLine.InvoiceLineItemRefFullName)<>"ship" And (tblInvoiceLine.InvoiceLineItemRefFullName)<>"rush") AND ((tblInvoiceLine.TemplateRefFullName) Like "Delivery Receipt" Or (tblInvoiceLine.TemplateRefFullName) Like "PP Work Order"));

Again, both of my front end queries work fine, so there's something wrong with the Union Query and QODBC.

Thanks!

Sorry, the use of UNION element will result with a: "Expected Lexical Element not found" error as the UNION element is not implemented in QODBC yet. You will need to pull the results of both queries into a temporary file and work with the results from there.

UNION is on the wish list .....

Sorry, QODBC v8.00.00.234 still doesn't except the following SQL syntax:

SELECT Name FROM Customer
Union Select Name from Vendor

or

SELECT Name FROM Customer
Union All Select Name from Vendor