[AccessD] Query Help

Thanks!  That is exactly what I needed!

Jamie
  -----Original Message-----
  From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of
jeffrey.demulling at usbank.com
  Sent: Monday, June 09, 2003 11:32 AM
  To: accessd at databaseadvisors.com
  Subject: Re: [AccessD] Query Help



  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/8dd35087/attachment-0001.html>