SQL Statment ??!!

[amal2004]

I have a table that has an [order id] column and a [rep id] column. An order could have two reps or more associated with. I would like a have a query that will bring me all the orders that have more than one rep associated with.

Thanks

 

[PHV]

Something like this ?
SELECT A.* FROM yourTable A INNER JOIN
(SELECT [order id], Count(*) FROM yourTable GROUP BY [order id] HAVING Count(*)>1) B
ON A.[order id]=B.[order id]
;

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[PHV]

Something like this ?
SELECT A.* FROM yourTable A INNER JOIN
(SELECT [order id], Count(*) FROM yourTable GROUP BY [order id] HAVING Count(*)>1) B
ON A.[order id]=B.[order id]
;

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244