HELP - select statement

From: zak <zak_at_intrafunk.com>
Date: Wed, 8 Nov 2000 16:19:40 +0200
Message-ID: <8ubnfl$200s$1@ulysses.noc.ntua.gr>

Hi all,

i've got two tables (people, organizations) and one more (employees) to link these two
in a many-to-many relation. I want to query the "people" table and when there is no data found (null values) in the columns (per_email, per_tel, per_addr), i
want to have their organizations contact data (org_email, org_tel, org_addr).

Is there a way to do this with nvl, decode or any other way?

here is a short description of the tables involved

people

---

per_id
per_email
per_addr
per_tel

organizations

---

org_id
org_email
org_addr
org_tel

employees

---

per_id
org_id

thanks in advance
zak Received on Wed Nov 08 2000 - 08:19:40 CST