Hi Guys,

I am attempting to get all records where and Id field exists more than once, trouble is my query is returning nothing and I have no idea as to why!? And this is the only method I know.

Here is my code:

        select 
[Customer Number], 
[Corporate Customer Number], 
[Order Date], 
[Order Number],
[Order No], 
[Order Line Status],
[Payment Method] , 
[ProcessOrder], 
[Order Platform] 

from Temp_ICOSOrder

    group by 
[Customer Number], 
[Corporate Customer Number], 
[Order Date], 
[Order Number],
[Order No], 
[Order Line Status],
[Payment Method] ,
[ProcessOrder] , 
[Order Platform]

    having COUNT([Order Number]) > 1

Any help is much appriciated!