Join 3 table

how to join with 3 tables or more?

10th Jan 2017, 2:32 AM
rizky syahferi
rizky syahferi - avatar
3 ответов
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
10th Jan 2017, 12:44 PM
Ayomide Kolawole
Ayomide Kolawole - avatar
right join and left join or inner join
10th Jan 2017, 8:21 PM
afgprogrammer - avatar
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
16th Jan 2017, 7:49 PM
Ben Rivera