[AccessD] Query Help

jeffrey.demulling at usbank.com jeffrey.demulling at usbank.com
Mon Jun 9 11:32:27 CDT 2003


Try this:

SELECT Customers.CustID
FROM Customers INNER JOIN Policies ON Customres.CustId = Policies.CustID
GROUP BY Customers.CustID
HAVING (((Count(Policies.CustID))=1));
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030609/78769fc1/attachment-0001.html>


More information about the AccessD mailing list