left join, right join and inner join?
Utilisateur anonyme
Left Join: It returns the rows from the left table where matching the rows from the right table. Right Join: It returns all rows from the right table that do not match any row with the left-hand table and the matched rows from the left-hand table. Inner Join: It returns the rows which are common from both the tables.