i was told to write a querie based on the informations they provided , while performing left join the result we get include all the table from the left table or first table and the matching records from the right table. whereas in inner join only the common columns in both the table is returned .