Re: SQL-Question

Juergen Pelz (pelz_at_zdf.de) wrote:
: Hi SQL-world,
: I have a simple SQL-question perhaps with an simple SQL-answer.
: There are one Master- and three Slave-Tables. There is no connection
: between these Slave-Tables. The Slave-Tables can contain different
: counts of Datasets according to the Master.
 

: select master.titel, slave1.name, slave2.address, slave3.holidaylocation
: from master, slave1, slave2, slave3
: Where master.id=slave1.idmaster(+)
: and master.id=slave2.idmaster(+)
: and master.id=slave3.idmaster(+);
 

: gives me:
 

: TITEL NAME ADDRESS HOLIDAYLOCATION
: -------------- ---------------- -------------------
: -----------------------
: a pelz wiesbaden mallorca
: a pelz wiesbaden elba
: a pelz wiesbaden naxos
: b ZDF mainz
: b ZDF berlin
 

: etc....
 

: but I like to have:
 

: TITEL NAME ADDRESS HOLIDAYLOCATION
: -------------- ---------------- -------------------
: -----------------------
: a pelz wiesbaden mallorca
: a elba
: a naxos
: b ZDF mainz
: b berlin
 

: etc....

: Is there anybody, who can tell me, which SQL-Statement will be mine??
 

: Thanks a lot,
 

: Juergen Pelz.
 

: email: pelz_at_zdf.de
: tel: 49 - 6131 - 703608

break on title on name on address

: select master.titel title, slave1.name name, slave2.address address, slave3.holidaylocation
: from master, slave1, slave2, slave3
: Where master.id=slave1.idmaster(+)
: and master.id=slave2.idmaster(+)
: and master.id=slave3.idmaster(+)
order by 1, 2, 3;

I hope it helps...

Srini Kunamneni Received on Thu Jul 04 1996 - 00:00:00 CEST