Posted by Artie on 10/23/07 18:52

Hi,
I was hoping somebody could assist me with this. I need to find accounts
that do not contain a contact person called 'Accounting'. Each account may
contain multiple contacts.

Here's my query to find accounts that DO contain an 'Accounting' contact:

SELECT company.code, company.name, company.type,
contacts.fullname
FROM company INNER JOIN
contacts ON company.code = contacts.code
WHERE (company.type in ('C', 'R')) and (contacts.fullname =
'Accounting')
order by company.code


How do I find accounts that DO NOT contain an 'Accounting' contact?

Thanks

• Next in forum: Re: Not Exists joining 2 tables
• Prev in forum: Re: Wrong result Set when using NoLock
• Thread view: Not Exists joining 2 tables

[Reply to this message]