Main Board > ODBC
Join Tables Error Identifier
(1/1)
eldonfsr:
I have this SQL statements but when is executed send a error not found indentifier
select PurchaseOrderNumber, PurchaseOrderDate, Vendorname, ItemNumber from { oj #PO1_PurchaseOrderEntryHeader INNER JOIN #PO2_PurchaseOrderEntryLine ON #PO1_PurchaseOrderEntryHeader.PurchaseOrderNumber = #PO2_PurchaseOrderEntryLine.PurchaseOrderNumber } WHERE PO1_PurchaseOrderEntryHeader.PurchaseOrderDate = {d"2015-08-05"}
what i doing wrong...
Devon Austen:
Is the # symbol part of the table name?
If it is not then it likely is the problem as that is not supported syntax.
If it is part of the table name then it looks like it is missing from the WHERE clause.
eldonfsr:
select * from { oj PO1_PurchaseOrderEntryHeader INNER JOIN PO2_PurchaseOrderEntryLine ON PO1_PurchaseOrderEntryHeader.PurchaseOrderNumber = PO2_PurchaseOrderEntryLine.PurchaseOrderNumber } WHERE PO1_PurchaseOrderEntryHeader.PurchaseOrderDate = {d"2015-08-05"}
even i write without # is the same message...
Devon Austen:
Are the table names all correct and is that the correct field names?
If you do it without the WHERE clause to test does it work?
Navigation
[0] Message Index
Go to full version