Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> How to do the SELECT?
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