RDBMS Table join
There are three types of join
There are 3 kinds of join INNER, LEFT OUTER, RIGHT OUTER and each
requires an ON clause to let the RDBMS know what fields to use joining
the tables. For each join there are two table the left table and the
right table. The syntax being the following
Click Here for Details