Re: Tables not able to join in same datasource

Aruna Akella — Fri, 02 Jul 2010 22:02:17 GMT

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.

Tables not able to join in same datasource

delux269 — Fri, 02 Jul 2010 18:20:34 GMT

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

General

Re: Tables not able to join in same datasource

Tables not able to join in same datasource