At 04:46 AM 9/02/2012, raistware wrote:

>Hi
>
>Im trying a bit difficult select:
>
>select id, value
>from MyTable
>where id in (1, 1, 1, 2, 3, 3, 4)
>
>I want that fore every value inside IN a row is output, so for example this would result something like:
>1 | 40
>1 | 40
>1 | 40
>2 | 21
>3 | 23
>3 | 23
>4 | 87
>
>But now I don't take duplicates, result is
>1 | 40
>2 | 21
>3 | 23
>4 | 87

Which is a correct result. The IN() predicate resolves to a series of ORs so, logically, it is the only possible result.

>Can someone help me to create that tricky select?

Why not just

where id between 1 and 4
?

./heLen