Re: SELECT WHERE IN help

[Mark Goodge]

On 21/09/2010 16:44, Tompkins Neil wrote:
> Thanks for the quick reply.  Basically in (3,4,5,6,7,3) the record_id of 3
> only exists once in the table my_table.  However, because 3 exists twice
> within  (3,4,5,6,7,3), I want it to return two records for record_id 3.  Is
> it possible ?

No, that isn't possible.

Why do you want a duplicate record to be retrieved? There may be a 
better way of doing it.

Mark
-- 
http://mark.goodge.co.uk