> 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
>
> Can someone help me to create that tricky select?

My SQL area of my brain doesn't work very well today, so I guess the
only way to do that is via a stored procedure, but this won't be very
flexible.


--
With regards,
Thomas Steinmaurer (^TS^)
Firebird Technology Evangelist

http://www.upscene.com/
http://www.firebirdsql.org/en/firebird-foundation/