Code:select * from lot where (issueid,quantity) in ( select issueid, quantity from lot where trunc(createdate) = TO_DATE('06/16/2003','MM/DD/YYYY') or trunc(createdate) = TO_DATE('06/17/2003','MM/DD/YYYY') group by issueid, quantity having count(*) > 1 )




Reply With Quote