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.