Re: HELP - NVL or DECODE

In article <8ub9jg$1ibo$1_at_ulysses.noc.ntua.gr>,   "zak" <zak_at_intrafunk.com> wrote:
> Hi all,
>
> i've got two tables (people, organizations) and one more 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 (email, tel,
 address), i
> want to have their organizations contact (email, tel, address) data.
>
> thanks in advance
> zak
>

Zak, I think it would help if you posted your query. Where is the data that you want that may be null coming from? Is it in the people table or in the organization table?

You might want an outer join where you always get the row from the people table and null values for organization when there is not matching organization row OR

You may want the result of selecting all rows from people where the people row is not in a join of people to organization, i.e., the result of an anti-join.

I can't tell from your initial post. Perhaps someone else will read it different and post your solution.

--
Mark D. Powell  -- The only advice that counts is the advice that
 you follow so follow your own advice --


Sent via Deja.com http://www.deja.com/
Before you buy.