Thanks Russell; it looks like you also had a problem with inner joins and I'm still fighting that issue....
I tried aliasing the tables and refering to the aliases in the DA Results page code but it complains it can't find the item.
The DA Search parameter does not have the alias and lists the 2 fields in the SQL, and that's confusing the engine - were you able to resolve this issue?
SELECT cs.id as ID, g.CustName, c.name, cs.centerid as Store, cs.contactid as Contact, cs.defaultstore as defaultstore
FROM dbo.contact c INNER JOIN dbo.contactinStores cs ON c.contactid = cs.contactid INNER JOIN dbo.GPCWebViewCust1 g ON cs.centerid = g.CenterID