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

Home -> Community -> Usenet -> c.d.o.server -> Re: How to do the SELECT?

Re: How to do the SELECT?

From: Vadim Grepan <kezal_at_mail.ru>
Date: Fri, 29 Oct 1999 12:43:47 +0400
Message-ID: <7vbmsb$1soh$1@storm.comstar.ru>


Hello!
AK пишет в сообщении <38194BC5.BB30D845_at_sqli.fr> ...

>I thinks that it works :

> SELECT TEMP.COL1,TEMP.NAME,TEMP1.COL1,TEMP1.COL2
> FROM TEMP,TEMP1
> WHERE TEMP.COL1=TEMP1.COL1
Then you'll get smth like
 01       AA                              01    TEST
 02       YY                             02    TEST1


You should try
SELECT t1.col1, NVL(t2.col, 'none')
FROM temp t1, temp1 t2
WHERE t1.col1=t2.col1(+)

HTH Rgds, Vadim Grepan



kezal_at_mail.ru
2:5020/653_at_fidonet.org Received on Fri Oct 29 1999 - 03:43:47 CDT

Original text of this message

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