Multiple Access JOINS

For every join greater than 1, the expression needs to be enclosed in parethesis.

SELECT field1, field2, field3...fieldN FROM
(
   (
     (
       Table1
       {LEFT/RIGHT/INNER} JOIN Table2)
     {LEFT/RIGHT/INNER} JOIN Table3)
   {LEFT/RIGHT/INNER} JOIN Table4)
 {LEFT/RIGHT/INNER} JOIN Table5

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s