I created this article/test page a number of years ago that describes Inner, Left, Right, Full, Cross, Triple, Self, Union and Union All queries. Joins[/url]