Tweet
Select * from FILEA A where a.key1 not in (select b.key1 from FILEB B) Chris
-
-
Finding Unmatched records
Can anyone tell me how to find records on one file that are not on the other file? I'm trying to get a list of records on FILEA that aren't on FILEB. The key field for both records is named key1. I tried the following: Select * from FILEA A , FILEB B where a.key1 <> b.key1 , but I got a list of every record on FILEB for each record on FILEA (except the one that matched). Thank You Very Much dbizon
Comment