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 -> How to do the SELECT?

How to do the SELECT?

From: Violin <violin.hsiao_at_mail.pouchen.com.tw>
Date: 29 Oct 1999 06:33:18 GMT
Message-ID: <381c3fd9.8184029@172.16.7.5>


Hello,
If I have 2 tables:TEMP and TEMP1

TEMP                             TEMP1
-----------------------           -----------------------
COL1    char(2)            COL1       char(2)
NAME  char(10)          NAME1  char(20)

The rows in both tables are:
TEMP                                   TEMP1
----------------------                  --------------------------
01       AA                              01    TEST
01       BB                              02    TEST1
01       CC
02       YY
02       ZZ

How to SELECT the result?

SELECT RESULT


01       AA                              01    TEST
01       BB                              
01       CC
02       YY                             02    TEST1 
02       ZZ

Thanks in advance.

Violin.
violin.hsiao_at_mail.pouchen.com.tw Received on Fri Oct 29 1999 - 01:33:18 CDT

Original text of this message

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