Inner join query

  • Thread starter Thread starter Warrio
  • Start date Start date
W

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.
 
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
 
You can do Inner Joins easily. Outers are tougher.

Select Table1.PK, Table2.PK, Table2.FK from Table1, Table2
WHERE table1.PK = Table2.FK
Click to expand...

Note that this "where clause join" will generally not be updateable.
 
John Vinson said:
Note that this "where clause join" will generally not be updateable.
Click to expand...

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

Cheers,
TC
 
Back
Top