Help With "Join Types" when setting up relationships

[MikeyBoi]

Ok here goes another Newbie question, I've been doing a lot of reading on the web and in books about relationships and setting them. But when I go to Access and set the relationships, theres a button called "Join Types". When clicked it brings up the "Join Properties" window with these three options in it:

1. Only Include rows where the joined fields from both tables are equal.

2. Include ALL records from "Company" and only those records from "Customer" where the joined fields are equal.

3. Include ALL records from "Customer" and only those from "Company" where the joined fields are equal.

I think im having trouble understanding what exactly these are refering to. The terms I think are throwing me off. If I had a table called "Company" with all the common info in it like name, address and such, What exactly is the "ROW" in that table, and the "RECORDS" of the table.

I think I need clarification on this so I can properly identify them, also if its possible could somebody supply an example for when I would use each join type? Your help is much appreciated. Thanks! ~[MikE]~

 

[RuralGuy]

Rows and records are the same thing in Access.

 

[neileg]

Just to add to RG's answer:
Rows and records are the same thing. Columns and fields are also interchangable terms.

The type 1 join is known as an inner join. Any records that do not have a corresponding record in the other table (either way) will be excluded from the results.

Type 2 joins are known as left joins. Every record from the first table (ie the one on the left) is included and any records that match from the second table are included.

Type 3 joins are right joins. All the records from the second table are included and any records from the first table that match are included.