How to do the SELECT sql ?

From: Violin <violin.hsiao_at_mail.pouchen.com.tw>
Date: 2 Apr 1999 02:38:32 GMT
Message-ID: <3704291f.6702527@news.twsc.pouchen.com.tw>

Hello all,
I have a SELECT question.
If I have 2 tables : PAYMENT and INVOICE

PAYMENT                               Example of PAYMENT


---------------------------------         ---------------------------------


pay_no        CHAR(4)             0001          5500
pay_amt      NUMBER(6)

INVOICE                                   Example of INVOICE


---------------------------------         --------------------------------


pay_no       CHAR(4)              0001     A00001    2850  150    
inv_no         CHAR(10)            0001     A00002   2425    75
inv_amt       NUMBER(6)
inv_tax         NUMBER(6)

How to have the result ?

PAY_NO PAY_AMT INV_NO INV_AMT INV_TAX

0001             5500               A00001     2850             150
                                               A00002     2475             75

Received on Thu Apr 01 1999 - 20:38:32 CST