Posted by bbcrock on 03/06/07 18:39

This is the time when I mention that I purchased Joe Celko's "SQL For
Smarties" several years ago and felt it was a great companion for
learning standard SQL theory. I recommend the book for everyone who
wants to take it to the next level.

I suspect that this entire database I inherited from a group project
of multiple contractors will have to be overhauled to achieve true
third normal form, but cannot be for financial and scope reasons.

I certainly was able to identify 3 mutual columns between the trucks
and trains and can suggest building a join table with that data and a
vehicle_ID that's used as the join with the transportation_item.

thanks!

[Back to original message]