Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: How to do the SELECT sql ?
SELECT PAY_NO, PAY_AMT, INV_NO, INV_AMT, INV_TAX from PAYMENT, INVOICE where
PAYMENT.pay_no = INVOICE.pay_no
Clauses like
GROUP BY pay_no ORDER BY pay_amt ASC
can be added to the statement.to group orders and sort in ascending order
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 - 00:22:13 CST