Query Help

From: Robert Nurse <rnurse_at_cudbytech.net>
Date: 29 Jul 2004 10:34:32 -0700
Message-ID: <a967f5b9.0407290934.433fc1b8@posting.google.com>

Hi All,

I've got a report to do and I need a little help with the query. Here's the table structure

rowID PK
descriptiveName
Col2 FK
Col3
Col4
Col5
Col6

Col3 through Col6 contain values taken from rowID. Just as a side note, this table is not normalized. Correct? Anyway, when I query the table instead of displaying the data in Col3 through Col6, I'd like to display the corresponding descriptiveName for those values. Could someone give me a hint at a PL/SQL solution for this? I'm new to PL/SQL. Received on Thu Jul 29 2004 - 12:34:32 CDT