What is the corilation beteen Left and Right Joins in the Join Properties dialog box?

  • Thread starter Thread starter Kelvin
  • Start date Start date
K

Kelvin

What is the corilation beteen Left and Right Joins in the Join Properties
dialog box?

I'm working on a Stored Procedure in SQL Server and trying to duplicate the
query in an Access Query to do some testing and need to understand how to
translate the SP into an Access Query...

Any help would be appreciated

Kelvin
 
Kelvin said:
What is the corilation beteen Left and Right Joins in the Join
Properties dialog box?

I'm working on a Stored Procedure in SQL Server and trying to
duplicate the query in an Access Query to do some testing and need to
understand how to translate the SP into an Access Query...

Any help would be appreciated

Kelvin
Click to expand...
They work the same way. The "Left" and "Right" refer to the written sql
statement, not to the orientation of the objects in the grid.
In both Jet and SQL Server
tableA left join tableB
means "get all records from tableA, the one to the left of the 'join'
keyword, and only matching records from tableB"
 
Back
Top