I am writing a simple report that displays records from our customer table, a table that has no corresponding records in our contacts table.
My code entered in SQL Server 2005 is as follows:
select contractor.name,acctstatus, statusDetail, sales_person, loggedInBy,loginDate, lastUpdateBy, LastUpdateOn from contractor where contractor.name NOT IN (Select company_name from leads_contacts)
I keep getting an empty result set, but I know we have companies that have no assigned contacts.
Could you suggest a method to accomplish this?
December 8, 2008 7:25 PM
December 8, 2008 9:22 PM