I need samples of how to simplify Access's graphically nested Joins!

[steve728]

My current employer has MANY graphically created NESTED JOIN queries. They drive me crazy with their complexities and normally have duplications. Is there a a reference some place on-line or a textbook that will serve as a good help in re-constructing them into a more straight-forward simpler format.

I would just like to have a reference showing the typical way to simplify the complex query designer results.

I found the following sample:

Needed help decyphering:
INNER JOIN (People INNER JOIN UserList ON UserList.User_Username=ActivityCalls.Username)
ON People.Person_ID=UserList.Person_ID

This might work:

FROM UserList U
INNER JOIN ActivityCalls A
ON U.User_Username = A.Username
INNER JOIN People P
ON U.User_PersonID = P.Person_ID

This is great but I would like to see sum mo!

Thanks in advance,

Steve728

 

[randy700]

Does this help?
Understanding SQL Joins

Randy

 

[Crowley16]

unfortunately the query builder will tend to strip any formatting in your sql and you end up with a big mess when you save the query and open it again.

Also, if jet, you need to have the brackets around each level of join.

your best bet is probably to use the graphical builder to tidy things up, or use a text editor and cut and paste.

p.s. when cutting and pasting, careful you don't include tabs, query builder will behave strangely if you paste in tabs...

--------------------
Procrastinate Now!