0

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

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)

5th Jul 2017, 3:03 PM
Rahul Ghatwal
2 odpowiedzi
0
thank you bumpety
5th Jul 2017, 8:22 PM
Rahul Ghatwal
+ 1
SELECT * FROM employee LEFT JOIN salary ON employee.id = salary.eid WHERE salary.eid IS NULL;
5th Jul 2017, 4:41 PM
Bumpety