SQL

Raja T10y ago

Accepted answer

Hi, Try like

create table #A (empid int,salary money)

insert into #A values(1,1000)

insert into #A values(2,2000)

insert into #A values(3,3000)

insert into #A values(4,4000)

insert into #A values(5,5000)

select * from #A

create table #B (empid int,salary money)

insert into #B values(1,3000)

insert into #B values(2,4000)

select * from #B

select #A.empid,#A.salary from #A Left join #B on #A.empid=#B.empid

where #A.salary not in (select Salary from #B )

+1

select A.empid,A.salary,B.empid,B.salary from A leftouterjoin where A.empid !=B.empid

try this......

0

Try this

Select empid, salary from A

EXCEPT

Select empid, salary from B

0