what is the meaning of join in sql
a means for combining columns from one ( self - join ) or more tables by using values common to each . ANSI - standard SQL specifies five types of JOIN : INNER , LEFT OUTER , RIGHT OUTER , FULL OUTER and CROSS