Inner join query

[Warrio]

Hello!

Access Uses special join (inner, left and right join) that in the basic SQL
does not exist.
is there a similar way to have the same result using just conditions in the
clause Where?

Thank you for any suggestion.

 

[Allen Browne]

JOIN is very basic to all flavors of SQL.

It is imperative to get used to them.

 

[Chris]

You can do Inner Joins easily. Outers are tougher.

Select Table1.PK, Table2.PK, Table2.FK from Table1, Table2
WHERE table1.PK = Table2.FK



Chris

 

[John Vinson]

You can do Inner Joins easily. Outers are tougher.

Select Table1.PK, Table2.PK, Table2.FK from Table1, Table2
WHERE table1.PK = Table2.FK

Note that this "where clause join" will generally not be updateable.

 

[TC]

Note that this "where clause join" will generally not be updateable.

....which always drives me bonkers! I can't see any logical reason why such
joins should not be updatable.

Cheers,
TC