In a query with two tables, is there a way to pull records from one table based on excluding records from the second table? For example, I have one table with medical claims and a second with a list of hospital ID's for one group of hospitals. I want to pull all of the claims that DIDN'T go to any of the hospitals listed in the second table. Also, I'd like to do this without using SQL statements.
Any help would be appreciated!