Joins

 

Inner joins	Left Outer joins	Right outer join
For every student For every batch If join condition Is met Add to result	For row in a For row in b If condition is met Add to result + add all the rows from left	For row in a For row in b If condition is met Add to result + add all the rows from right
Combines the rows where both matches the condition
Time complexity:- n*m
Batch 1 from students will check for all the batch id in the batch table, even if it finds a match
It always works when a condition is matched by may not work if in case the condition has an id and that id is null, for such cases inner join doesn’t show the null id record