Need Help with Inner/Outer Joins

[tyleri]

As you might have noticed from my previous post I am converting my MS ACCESS queries to standard SQL for the pass-through queries.

I need a little help with inner and outer joines - (i am not sure what they are first of all).

All I do know is that I have one main table which includes a ton of records, and the other tables contain a few records.

How do I make it so the join "includes ALL RECORDS from MAIN table and only those records relative in LITTLE table?"

would it be something like "...where maintable.id = littletable.id ? or is that a join where only matching records show up?

Thanks!

 

[braindead2]

In a nutshell
Inner join is where they are equal. Left and Right joins will include all the records from one table and only records that match from the other. Where is a criteria that brings in records that match tat criteria