join querry is used for joining two tables there are different join querries join,left outer join, right outer join, self join etc For joining there specify both tables except self join, it is used for joining single table.