Re: How to do the SELECT?

in sqlplus?

use break
 (break on <thethirdcolumn> on <thefourthcolumn>)

Further the sql is straight forward I presume?!

Violin wrote:

> 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 - 03:39:10 CDT