Need help..... write a Query to show the name of employee who dint get salary using both the tables?

Question

there are two tables
emp and salary

emp--> id,name, department
salary--> fk(eid),salary.

emp table-->(1,ram,hr)( 2,John,it)(3,leo,it)
salary table-->(1,4000)(2,5000)

Answer 1

thank you bumpety

Answer 2

SELECT * FROM employee LEFT JOIN salary ON employee.id = salary.eid WHERE salary.eid IS NULL;