Inner Join --> Only records from both tables that match the join criteria, the most common type of join.

Left Join --> All records from the table on the left side of the join criteria and only records that match the join criteria from the table on the right side of the join criteria.

Right Join --> All records from the table on the right side of the join criteria and only records that match the join criteria from the table on the left side of the join criteria.

Full Join --> All records from both tables whether or not they match the join criteria.



>Hey everyone,
>I'm trying to show someone what a great resource the UT is. Somebody wanna explain to us what a left join is? Thanks,
>
>jfh