SQL

Question

I have two table A & B. table A has column empId and salary. values are empid salary 1 1000 2 2000 3 3000 4 4000 5 5000 table B has column empId and salary. values are empid salary 1 3000 2 4000 i want output for table A ----select those row of A that is not in B i want output empid salary 1 1000 2 2000 5 5000 please give answer using Joins.

Raja T · Answer

Hi Try like create table #A (empid intsalary money) insert into #A values(11000) insert into #A values(22000) insert into #A values(33000) insert into #A values(44000) insert into #A values(55000) select * from #A create table #B (empid intsalary money) insert into #B values(13000) insert into #B values(24000) 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 )

Gantasala Venkatanarayanamurth · Answer

select A.empidA.salaryB.empidB.salary from A leftouterjoin where A.empid !=B.empid try this......

Ranjit Powar · Answer

Try this Select empid salary from A EXCEPT Select empid salary from B