Re: How to do the SELECT sql ?

User SQL break statement to achieve the same.

In your case break on pay_no, pay_amt and try executing your query.

Thanks,

Vrajesh.

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 16 1999 - 11:34:07 CDT