Join Tables Error Identifier

[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?