
September 29th, 2004, 04:35 PM
|
|
Registered User
|
|
Join Date: Sep 2004
Posts: 3
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
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..
Quote: | Originally Posted by skwak2 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.. |
|