Re: distinct clause issue for 600000 records
It's doing exactly what the Left Join tells it to do: retrieve an ee.id for each prd row whether that prd.id matches ee.id or not.
Lose the 'left' modifier.
Subject
Views
Written By
Posted
2047
November 10, 2015 08:57AM
Re: distinct clause issue for 600000 records
1141
November 11, 2015 12:33PM
1027
November 12, 2015 12:49AM
1138
November 12, 2015 03:20AM
1041
November 12, 2015 07:24PM
1253
November 12, 2015 07:08AM
1243
November 12, 2015 07:18AM
1295
November 12, 2015 07:43AM
1162
November 13, 2015 12:37AM
1282
November 13, 2015 12:45AM
1314
November 13, 2015 02:42AM
1319
November 13, 2015 05:56AM
1120
November 13, 2015 06:38AM
1210
November 13, 2015 07:15AM
1176
November 13, 2015 08:11AM
1136
November 13, 2015 11:35AM
1206
November 16, 2015 03:04AM
1137
November 16, 2015 04:12AM
1075
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.