Joininig three tables

Question

my query is suppose we have three tables employee , department and building and I want aquery which could fetch me emp_name, phone_no,building name where emp_id=20. so how do i put where condition in the join of three tables?

Answer 1

This will do the magic for you.

select emp_name, phone, dep_name, building_name from employee e inner join dep d on e.emp_id = d.emp_id inner join building b on b.building_id = d.building_id;