Woody, > > Im trying a bit difficult select: > > > > select id, value > > from MyTable > > where id in (1, 1, 1, 2, 3, 3, 4) > > > > Try: > > select DISTINCT id, value > from MyTable > where id in (1, 1, 1, 2, 3, 3, 4)
You have misunderstood the Ops question. That would give him the exact same result he is seeing now. He wants 1 row for each IN () list item, including duplicates -- which runs against conventional logic. The only solution I can see is a UNION ALL, but that would be a very ugly SQL. Sean
