Software

Ask something
Discussion Locked

The JOIN from hell...

0 helpful
2 replies

by airwhale

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

OK, I'm building a database application in Access 2002, and I have 14 tables that I need to JOIN toghether nicely. I have a hard time getting Access to accept my syntax, so I'm probably not doing it right. (The code Access produced itself from the wizard didn't work either :)

Anyway - these tables are generally the "contact" table (leftmost) and the rest are normalized tables with relations to "contact". They are set up in two levels, first a "cross-reference" table and then a "values" table. The cross-ref contains the contact-id and the value-id only.

Now, finally to the question:
How do I go about JOINing these. Do I start at the first level and join in those first (i.e. all cross-ref tables first, then all value tables), or do I need to go to the bottom with each branch before starting on the next (i.e. first cross-ref, then value-table, next cross-ref, next value-table).

Any pointers would be apreciated - TIA!

peace,
Tormod in Stockholm

2 replies

by ghopkins

Just out of curiosity, what might a real database be? Having designed, priced, sold and sized systems to support everything from a desktop to 36 Alpha Servers for one database, what is your cost effective alternative? Keep in mind, I hate Access!
I look forward to being enlightened, as soon as you have time.

All the best,
Greg

This discussion is closed to new replies.