>
>Is there a quick and dirty diagram anywhere that shows what these all do? I know what the help says they do, but anyone know of a quick reference that simply shows them in an example? I'm thinking of something like a set diagram with circles. Thanks!>
>Don't have one handy but think of two intersecting circles. Two sets of data. The shaded part that both circles have in common, is what you get with INNER. The left circle is the left side of the query (first table) and what you get with LEFT JOIN or LEFT OUTER JOIN.
>
>RIGHT gives you the table on the right.
>
>So,
>SELECT * FROM TableA INNER JOIN TableB ON TableA.key=TableB.key will get you the records that match in both tables.
>
>LEFT JOIN will give you all the records in TableA and the ones in TableB that match the relationship.
>
>[Update] Just found one:
>
http://www.khankennels.com/blog/index.php/archives/2007/04/20/getting-joins/>
>Here's another one (excuse the product)
>
http://www.databasedev.co.uk/query_joins.htmlAlex, this is the most clear and yet succint explanation of joins I have ever seen anywhere. Kudos!
Thank you!
=========================
PabloSr, Still Learning!
DevDBFox