Multi-table join condition

From: Artful Dodger <dodger_at_spamfilter.answerdude.net>
Date: Sat, 26 Oct 2002 22:39:40 -0400
Message-ID: <apfjld$37e$1@news.storm.ca>

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 Sat Oct 26 2002 - 21:39:40 CDT