What is Join.?

Join: it joins the loaded table with an existing named table or last previously created logical table.
Join are of 4 types

1. Inner Join  
2. Outer Join  
3. Left Join 
4. Right Join