I have a report which uses an SQL database. I have 4 tables which are linked in the report.
The first table references the second table on a field called "Part_id". What I want to select is those records in the first table which DO NOT exist in the second table.
I have tried "select...from..... WHERE Part_ID in secondtable IS NULL AND blah.blah.blah...
the program just hangs in preview mode with reporting services. Cannot seem to figure this out.
Any help or booting in the correct direction would be appreciated.