Hello all.<BR>I'm not a big SQL guru so I do need some help from you, good people. Here is what I have: two tables (tbl1 and tbl2, both have same structure (id and 3 other fields). Now here is what I need. I need to select all records in tbl1 that arent in tbl2 and all records in tbl2 that arent in tbl 2 (in two separate steps). I've done some research and I think I need to use NOT IN. But I have a problem with syntax. Could someone please show me how it's done. (I'm not asking to write a query for me, just some generic stuff)<BR>Thanks in advance.