Re: Query is duplicating the results
Posted by:
John Noble
Date: November 20, 2018 05:39AM
Hi there,
I have found the solution....
INNER JOIN
(SELECT * FROM salesLedger WHERE paymentNo = p_paymentNo LIMIT 1)
SALESlEDGER
ON SALESLEDGER.PAYMENTnO = RECEIPTS.PAYMENTNo *** LIMIT 1 ***
Subject
Written By
Posted
November 19, 2018 06:10AM
November 19, 2018 08:30AM
November 19, 2018 10:03AM
November 19, 2018 01:54PM
November 19, 2018 04:30PM
November 19, 2018 05:27PM
November 20, 2018 05:06AM
Re: Query is duplicating the results
November 20, 2018 05:39AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.