Re: How to do the SELECT?

I thinks that it works :

    SELECT TEMP.COL1,TEMP.NAME,TEMP1.COL1,TEMP1.COL2     FROM TEMP,TEMP1
    WHERE TEMP.COL1=TEMP1.COL1 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 - 02:24:53 CDT