0

Write a query to Display all employees of mumbai and london reference to employes table and location table

26th Mar 2017, 5:40 PM
Kuldeep Kaluvala
Kuldeep Kaluvala - avatar
3 ответов
+ 4
select employes.ename, employess.empid, location.country,location.empid from employee natural join on country = "london" and employee.empid = location.empid
26th Mar 2017, 5:52 PM
Mayur Chaudhari
Mayur Chaudhari - avatar
+ 3
then on location.contry = "london" and location.city = "mumbai" where employee.empid = location.empid
26th Mar 2017, 5:56 PM
Mayur Chaudhari
Mayur Chaudhari - avatar
0
for mumbai
26th Mar 2017, 5:53 PM
Kuldeep Kaluvala
Kuldeep Kaluvala - avatar