Join 3 table

Question

how to join with 3 tables or more?

Answer 1

you have to use the join keyword, Left Join, Inner Join etc.. you can read up on the join keyword here http://www.dofactory.com/sql/join

Answer 2

right join and left join or inner join

Answer 3

Depends on how you want to join them.
For example:
SELECT * FROM Employees as E1
Inner Join Employees as E2 on E1.managerID = E2.employeeID
Right outer join Sales as S on S.salespersonID= E1.managerID
Left outer Join CommissionRates as R on E1.Ccode = R.CommissionRateCode