I have two tables that I want to join. They are both contained in the same datasource. I am trying to get them to join together in an SQL statement. The SQL is the correct syntax. The syntax is:
select PurchOrd.PONbr,PurOrdDet.InvtID from PurchOrd JOIN PurOrdDet ON PurchOrd.PONbr=PurOrdDet.PONbr WHERE ...