Hard to explain One order different operations 1

[evr72]

Hello,

this is a bit hard to explain, have a file that has two fields order and operation. Each order can have one or more operations.I am trying to write a query that capture the orders that only have one operation. This is what my data looks like

order	operation
O1234	1111
O1234	1120
O1234	1130
O1234	1160
O1234	1170
O3456	1111
O7890	1111
O7890	1120
O7890	1130
O6543	1111

so my ending query would look like this

order	operation
O3456	1111
O6543	1111

Thanks in advance!!!

 

[PHV]

capture the orders that only have one operation

SELECT [order] FROM yourTable GROUP BY [order] HAVING Count(*)=1

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[evr72]

PHV,

that was a very fast, simple and effective solution. Thank you!!!!! you rock!!!