Help with this Select statement please

From: harry <spammemothers_at_yahoo.co.uk>
Date: Tue, 26 Apr 2005 14:50:46 GMT
Message-ID: <azsbe.19959$G8.15487@text.news.blueyonder.co.uk>

Using Oracle 9i on win 2000

I have 2 tables

Customer                      Importance
=======                     ==========
cust_id                          id
priority_id                    descr

status_id

priority_id & status_id are both foreign keys for the Importance table's primary key id field.

I'm trying to work out how to construct a SELECT statement like - select cust_id, descr (based on priority_id), descr (based on status_id) but as they are in the same table it's really confusing!

Any ideas?

Hope I've explained this clearly?

thanks

harry Received on Tue Apr 26 2005 - 09:50:46 CDT