CareerCup

create table t1(id int, name varchar(20))
create table t2(id int,name varchar(20))
insert into t1 values(1,'abc')
insert into t2 values(1,'abc')
insert into t2 values(2,'abc')
insert into t1 values(3,'abc')

select t2.* from t2 left join t1 on t1.id = t2.id where t1.id is null

{sel * from test_vinod t2
where t2.id not in
(sel tv.id from test_vinod tv
join test_vinod_1 tv1 on tv.id = tv1.id)}

-- Without using Join
select * 
from testDept
where DeptId NOT IN (select distinct DeptId from testEmp)

-- With Join
select td.DeptId, td.DeptName
from testDept td left join testEmp te
on td.DeptId = te.DeptId
where te.DeptId is null

create table A
( id int,
  name text
 );


insert into A values(1,'aa');
insert into A values(2,'aaa');
insert into A values(3,'aaaa');

create table B
( id int,
  name text
 );


insert into B values(3,'bb');
insert into B values(4,'bbb');
insert into B values(5,'bbbb');

Query:

select B.* from B
left outer join A
on B.id = A.id where A.name is null ;

OUTPUT:
ID	NAME
4	bbb
5	bbbb

How about

select distinct B.id,B.name
from B join A on B.id<>A.id

Select distinct B.id
from B join A on B.id<>A.id

SELECT B.data
FROM A LEFT OUTER JOIN B
ON A.key = B.key
WHERE B.data ISNULL

select * from B where B.name not in(select A.name from A left outer join B where A.id=B.id)

SELECT t2.* FROM t2 MINUS SELECT t1.* FROM t1;