InfoPath Dev

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 PurchOrd.PONbr LIKE '%" + PONbrId + "%' AND PurchOrd.ProjectID LIKE '%" + ProjectId + "%' AND VendName LIKE '%" + VendorNameId + "%' AND PurchOrd.ReqNbr LIKE '%" + PRNbrId + "%' AND PurchOrd.User6 LIKE '%" + ReqId + "%'"

 The fields for PurchOrd display just fine, but the fields for PurOrdDet do not display at all, and I cannot figure out why

Have you tried using the same query in SQL? Does it return the correct number of rows?

I just tried using join, and it returns all the specified rows of data in InfoPath.