We have two tables:
create table emp
(
emp_id int,
emp_name varchar(10)
)

create table sal
(
emp_id int,
sal float
)

Show all employees who did not receive their salary...in other words show those emp_names from the 'emp' table whose emp_id does not exist in the 'sal' table. Use joins only. Sub Query is not allowed.

do your home work your self .

kindly post what you have tried sofar

please clear which database u r using and why you want the same using join as usnig NOT IN and subquery you can execute the query with better efficiently.

debasisdas --this not my homework...just an interview question i am trying to solve. This was asked in my last inteview.

sarikagupta -- use any database. These tables are an example. Using subquery would not be more efficient as you would have to select all rows of the sal table in the subquery.

select emp_name from emp where emp_id not in (select emp_id from sal)

Need to do this using only joins.

Sub query is the best solution to avoid anti-join.