in reply to Advise on sql table mapping.

I think you are missing som important info in your file: the type of the join.

Are they all inner equi-joins? Or are some them left or right joins?

It will make a hell of a difference as you could loose a lot of relevant records by assuming it are all inner equi-joins

Also as soon as left or right joins are involved the solution is not symmetrical anymore as operations with outer joins (left or right) are not commutative. I'm not sure if they are associative, but a combination of inner and outer joins is certainly not associative.

CountZero

A program should be light and agile, its subroutines connected like a string of pearls. The spirit and intent of the program should be retained throughout. There should be neither too little or too much, neither needless loops nor useless variables, neither lack of structure nor overwhelming rigidity." - The Tao of Programming, 4.1 - Geoffrey James

Replies are listed 'Best First'.
Re^2: Advise on sql table mapping.
by dbmathis (Scribe) on May 18, 2008 at 20:02 UTC

    At this point left / right joins are not so important, however there will be situations where I will have "join table on a = b and b = c". I think for now I will work with getting a script functioning for basic joins and then move to something more complex.

    I already feel like I have jumped into the deep end without knowing how to swim :)

    After all this is over, all that will really have mattered is how we treated each other.
[reply]

In Section Seekers of Perl Wisdom