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...