Outer Joins in Access 2003

  • Thread starter Thread starter Pepper
  • Start date Start date
P

Pepper

I am trying to get a bit more sophisticated and was stumped on how to specify
which table will be left and which will be right.
A seemingly simple question which may not have simple answer.

Thanks
Pepper
 
In the SQL statement

FROM SomeTable Left Join AnotherTable
ON ...
Means that all records in Sometable and only records that match in
AnotherTable will be returned (in the absence of criteria)

FROM SomeTable RIGHT Join AnotherTable
ON ...

Means that all records in AnotherTable and only records that match in
SometTable will be returned (in the absence of criteria)

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
 
Pepper said:
I am trying to get a bit more sophisticated and was stumped on how to
specify
which table will be left and which will be right.
A seemingly simple question which may not have simple answer.
Click to expand...


If you're working in the query design window, you double-click the join line
between the tables to bring up the Join Properties dialog, then choose
whichever of the three options presented suits your purpose. That will
translate into an INNER, LEFT, or RIGHT join. The verbiage used in the
options presented in the dialog may clarifiy for you the nature of the join
you're creating.

If you're working in SQL view, you just specify <table1> INNER JOIN
<table2>, or LEFT JOIN, or RIGHT JOIN.

This response may not have answered your question. If that's the case,
please post back with a clarification.
 
Back
Top