Re: distinct clause issue for 600000 records
Posted by:
Ra Nala
Date: November 13, 2015 07:15AM
Sorry Sir @: Øystein Grøvlen, Not able to under stand your syntax : t1 LEFT JOIN (t2 JOIN t3 ON ...) ON ...
Could you please provide sample syntax for below tables, Don't mind please sir . .
I want to retrieve all data from prdsl .
select *
from prdsl psrl
left join prd prd on psrl.prdd=prd.prdd
left join be_en beship on beship.id=psrl.ship_bed
left join be_en beinv on beinv.id=psrl.invoice_bed
Subject
Views
Written By
Posted
2027
November 10, 2015 08:57AM
1124
November 11, 2015 12:33PM
1005
November 12, 2015 12:49AM
1122
November 12, 2015 03:20AM
1023
November 12, 2015 07:24PM
1228
November 12, 2015 07:08AM
1194
November 12, 2015 07:18AM
1236
November 12, 2015 07:43AM
1138
November 13, 2015 12:37AM
1232
November 13, 2015 12:45AM
1265
November 13, 2015 02:42AM
1274
November 13, 2015 05:56AM
1107
November 13, 2015 06:38AM
Re: distinct clause issue for 600000 records
1189
November 13, 2015 07:15AM
1158
November 13, 2015 08:11AM
1121
November 13, 2015 11:35AM
1187
November 16, 2015 03:04AM
1116
November 16, 2015 04:12AM
1061
November 16, 2015 05:54AM
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.