Below is what I'm trying to show in Crystal, it's a NOT EXISTS.

I need records from the employer table that are not in my view.

I know that Crystal doesn't have a way of doing NOT EXISTS so how do I set up the linking for this?

This is driving me crazy!

Any help would be greatly appreciated!




Code:
SELECT     employer_unique, employer_id, emp_state, Fulfillment_Pack_Completed_By
FROM         employer
WHERE     (NOT EXISTS
                          (SELECT     employer_unique
                            FROM          vwSPCompanyInfo
                            WHERE      (employer.employer_unique = employer_unique))) AND (Web_Update_Action <> 'DELETE') AND (Business_Structure = 'Sole Proprietor' OR
                      Business_Structure = 'Partnership') AND (employer_type <> 'G' OR
                      employer_type = 'L') AND (Fulfillment_Pack_Complete_Date >= CONVERT(DATETIME, '2008-09-13 00:00:00', 102)) AND (Status_Code = 'ENR')
ORDER BY Fulfillment_Pack_Completed_By, Fulfillment_Pack_Complete_Date Desc