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