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

Home -> Community -> Usenet -> c.d.o.misc -> Re: include NULL from a link?

Re: include NULL from a link?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 26 Jun 2002 17:27:16 +0200
Message-ID: <uhjnorqn53m417@corp.supernews.com>

"cyburgh" <cyburgh_at_yahoo.dot.com> wrote in message news:3D19C716.1A2100EA_at_yahoo.dot.com...
> Running Oracle 9i DB
> using Discoverer 4
>
> We have many master tables and many detail tables with many links.
> Here's simple example of my problem.
>
> STATE (master table): column 1 is state abbrev & col 2 is the state
>
> AK | Alaska
> AL | Alabama
> AR | Arkansas
> CA | California
> etc
> etc
>
> CUST_ADDR (detail table): col 1 - cust nmbr, col 2 - name, col 3 -
> city, col 4 - state, col 5 - zip.
>
> cust1|Jones|1 Main St.|San Fran|CA|12345
> cust2|Smith|First St|Los Ang|CA|54321
> cust3|Xiang|1 Holly St|Hong Kong|(null)|00101
>
> Without doing an outer join - how can a user have 1 Discoverer Query
> return all 3 customer records that would look something like:
>
> cust1|Jones|1 Main St.|San Fran|CA|12345|California
> cust2|Smith|First St|Los Ang|CA|54321|California
> cust3|Xiang|1 Holly St|Hong Kong|(null)|00101|(null)
>
> thanks
>

You can't.
This is why some people include dummy values in their tables.

Hth

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address
Received on Wed Jun 26 2002 - 10:27:16 CDT

Original text of this message

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