04pallav
9/13/2017 - 9:54 PM

Join 3 tables

Join 3 tables

SELECT column_Name1,column_name2,......
  From tbl_name1,tbl_name2,tbl_name3
  where tbl_name1.column_name = tbl_name2.column_name 
  and tbl_name2.column_name = tbl_name3.column_name
  
  
####### joining on two columns

select * from route a JOIN route b ON
  (a.company=b.company AND a.num=b.num)
  
  
####### joining multiple tables

FROM (TableB INNER JOIN TableA
  ON TableB.aID= TableA.aID)
  INNER JOIN TableC ON(TableB.cID= Tablec.cID)
  INNER JOIN TableA ta ON(ta.dID= TableD.dID)
WHERE (DATE(TableC.date)=date(now()))