Re: How to do the SELECT sql ?

select PAYMENT.pay_no,pay_amt ,inv_no,inv_amt,inv_tax from PAYMENT,INVOICE
where PAYMENT.pay_no=INVOICE.pay_no;

Violin wrote:

> 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 Fri Apr 02 1999 - 01:59:04 CST