Join Properties

[a]

Thank you

This message appear to me:

The SQL statement could not be executed because it contains ambiguous outer
joins. To force one of the joins to be performed first, create a separate
query that performs the first join and then include that query in your SQL
statement. (Error 3258)

I find the answer :

From JOIN PROPERTIES

I select No 2: and the query run … but I want to understand :>>>>>>>>>>>>>

1: only include rows where the joined fields from both tables are equal.

2: Include all records from "tblplayer" and only those records from
"tblplayercontactinformation" where the joined fields are equal.

3: include all records from "tblplayercontacinformation" and only those
records form "tblplayer" where the joined fields are equal.

My First Question

-----------------------------------------------------------------------------

What is 1: , 2: , 3: means???

In my heads

1:>>> mean one to one

2:>>> mean one to many

3: >>>mean many to many

Is this true

----------------------------------------------------------------------------------

My Second Question:

Is lift Join means (tables on the lift) in join properties)

Is right join means (tables on the right ) in join properties



Third Question:

What is inner join and outer join mean

I'm sorry but I learn by example and explanation

 

[Arvin Meyer [MVP]]

Thank you

This message appear to me:

The SQL statement could not be executed because it contains ambiguous
outer joins. To force one of the joins to be performed first, create a
separate query that performs the first join and then include that query in
your SQL statement. (Error 3258)

I find the answer :

From JOIN PROPERTIES

I select No 2: and the query run … but I want to understand :>>>>>>>>>>>>>

1: only include rows where the joined fields from both tables are equal.

2: Include all records from "tblplayer" and only those records from
"tblplayercontactinformation" where the joined fields are equal.

3: include all records from "tblplayercontacinformation" and only those
records form "tblplayer" where the joined fields are equal.


My First Question

-----------------------------------------------------------------------------

What is 1: , 2: , 3: means???

In my heads

1:>>> mean one to one

2:>>> mean one to many

3: >>>mean many to many

Is this true

No Joins are irrespective of type of relationship

----------------------------------------------------------------------------------

My Second Question:

Is lift Join means (tables on the lift) in join properties)

Is right join means (tables on the right ) in join properties

Yes. In Access usage a Join is an Equi-join or Inner Join and Left and Right
Joins are Outer Joins:

-----------------------------------------------------------------------------------

Third Question:

What is inner join and outer join mean

I'm sorry but I learn by example and explanation

http://en.wikipedia.org/wiki/Join_(SQL)