compare two tables..

i am trying to take out the row which doesn't match with other table..

i know if i use this sql i can take out same row from each tables.

select t1.grpid, t1.userid
from table1 t1, table2 t2
where t1.grpid=t1.grpid and t1.userid=t2.userid

i think the sqlscript should be exact opposite to that sqlscript..

thanks guys..

i used this SQL Script and worked fine..

select t1.grpid, t1.userid
from table1 t1, left outer join table2 t2 on t1.grpid=t2.groupid and t1.userid =t2.userid
where t2.userid IS NULL


thanks to me..? j/k..

thanks guys..