Simple Question... I hope 2

[Newbi1]

I have 2 tables Tbl1, tbl2 and both tables have a record in it: rec1.

What I need is a statement that will allow me to get all the records in tbl1 where they are not = to the record in tbl2.

 

[Juice05]

Use a Join or:

Select ID From Tbl1 Where ID Not In (Select ID From Tbl2)

 

[checkai]

the join method

select t1.rec1
From table1 t1 left join table2 t2 on t1.recid = t2.recid
where t2.recid is null

"...we both know I'm training to become a cagefighter...see what happens if you try 'n hit me..."

 

[Newbi1]

thanks... It slipped my mind