Xref: alice comp.databases.oracle.misc:45688
Path: alice!news-feed.fnsi.net!hammer.uoregon.edu!logbridge.uoregon.edu!newsfeed.berkeley.edu!ctu-gate!news.nctu.edu.tw!feeder.seed.net.tw!news.seed.net.tw!ron news.twsc.pouchen.com.tw 172.16.7.5 pouchen!172.16.7.103
From: violin.hsiao@mail.pouchen.com.tw (Violin)
Newsgroups: comp.databases.oracle.misc
Subject: How to do the SELECT?
Date: 29 Oct 1999 06:33:18 GMT
Organization: SEEDNet News Service
Lines: 31
Message-ID: <381c3fd9.8184029@172.16.7.5>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Newsreader: Forte Agent 1.5/32.478
X-Original-NNTP-Posting-Host: 172.16.7.103
X-Authenticated-User: news

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@mail.pouchen.com.tw