>What is the difference between a left join, right join and an inner join in a quick summary?

Matt,

Check out a book called The Practical SQL Handbook. It does a very good job of covering ANSI SQL including the different types of joins.

-Mike