dynamictiger
Registered User.
- Local time
- Today, 19:25
- Joined
- Feb 3, 2002
- Messages
- 270
The following is a query string I want to build in code (I think) to return specific records at runtime. I have knocked up a sample to get it to work first in the query window, however, every time I try and run it the query is telling me I need the keyword Exists. I have looked at my books and can't see a syntax for this keyword.
SELECT tblClientPoolSuburb.ID, qunLetterBase.ClientName, qunLetterBase.ClientAddress, qunLetterBase.ClientSuburb
FROM qunLetterBase INNER JOIN tblClientPoolSuburb ON qunLetterBase.ClientID = tblClientPoolSuburb.ClientID
WHERE (((tblClientPoolSuburb.ID) In (SELECT tblClientPool.PoolSuburb, tblPool.Type, tblPool.Construction, tblPool.PSanitiser, tblPool.PpHControl
FROM tblPool INNER JOIN tblClientPool ON tblPool.PoolMasterID = tblClientPool.Pool
WHERE (((tblPool.Type)=1) AND ((tblPool.Construction)=1) AND ((tblPool.PSanitiser)=1) AND ((tblPool.PpHControl)=1)))));
SELECT tblClientPoolSuburb.ID, qunLetterBase.ClientName, qunLetterBase.ClientAddress, qunLetterBase.ClientSuburb
FROM qunLetterBase INNER JOIN tblClientPoolSuburb ON qunLetterBase.ClientID = tblClientPoolSuburb.ClientID
WHERE (((tblClientPoolSuburb.ID) In (SELECT tblClientPool.PoolSuburb, tblPool.Type, tblPool.Construction, tblPool.PSanitiser, tblPool.PpHControl
FROM tblPool INNER JOIN tblClientPool ON tblPool.PoolMasterID = tblClientPool.Pool
WHERE (((tblPool.Type)=1) AND ((tblPool.Construction)=1) AND ((tblPool.PSanitiser)=1) AND ((tblPool.PpHControl)=1)))));