Multi-table Join Condition

I wasn't sure if this should go in comp.databases.oracle or ...misc, so I posted in both. My appologies for cross-posting (if I did...)

I've been tearing my hair out trying to figure out this problem, and have finally decided to bow to the omnipotent gurus on comp.databases.oracle.

I am attempting to create a view from a 3-table join. Instead of wasting your time trying to explain my problem in english, I've created an example of the 3 tables and the resulting view I'm trying to create as an HTML page, at http://www.storm.ca/~dodger/join_question.html

I initially would have thought this would be fairly simple, but the number of hours I've poured into this with zero results are beginning to take their toll on my sanity. If anyone knows of a simple solution which actually works, I'll be forever in your debt! If you reply by e-mail, please remove the "spamfilter" from my address.

Thanks,

Scott Received on Sun Oct 27 2002 - 03:44:44 CET