Finding Unmatched records

[dacust]

Select * from FILEA where key1 NOT IN(select key2 from FILEB) I think there is also a way with something like OUTER JOIN or something like that, but I can't remember it right now. -dan

[dmjae2004@yahoo.com]

Finding Unmatched records

I think you want a LEFT EXCEPTION JOIN as an LEFT OUTER JOIN will include all rows from TABLE1

---

Code

[Guest.Visitor]

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