Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Need help with SQL SELECT statement

Need help with SQL SELECT statement

From: Alessandro Nazzani <alessandro.nazzani_at_plurimedia.it>
Date: 19 Feb 2001 15:23:26 +0100
Message-ID: <003f01c09a7f$2f906450$0300005a@PlurimediaGE.it>

Hi all,

This should be simple, but I'm not an expert, so...

I have a table containing 3 columns that are primary keys in 3 different tables. Those key columns can have values or can be set to 0.

DATE ID_TABLE1 ID_TABLE2 ID_TABLE3

1-FEB-01 11 0 0
2-FEB-01 12 21 0
3-FEB-01 13 22 31
4-FEB-01 0 0 32

Table 1
ID_TABLE1 DESCR_TABLE1
11 Description11
12 Description12
13 Description13

Table 2
ID_TABLE2 DESCR_TABLE2
21 Description21
22 Description22

Table 3
ID_TABLE3 DESCR_TABLE3
31 Description31
32 Description32

What I need is a query to retrieve all records in this table and the description column in the linked table (when the ID column is <> 0):

DATE DESCR_TABLE1 DESCR_TABLE2 DESCR_TABLE3

1-FEB-01 "Description11" " " " "
2-FEB-01 "Description12" "Description21" " "
3-FEB-01 "Description13" "Description22" "Description31"
4-FEB-01 " " " " "Description32"

How can I do that?

TIA for your support and patience.

Alessandro Nazzani

-- 
Posted from IDENT:root_at_net134-146.mclink.it [195.110.134.146] 
via Mailgate.ORG Server - http://www.Mailgate.ORG
Received on Mon Feb 19 2001 - 08:23:26 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US