List:General Discussion« Previous MessageNext Message »
From:Mark Goodge Date:September 21 2010 3:49pm
Subject:Re: SELECT WHERE IN help
View as plain text  
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
Thread
SELECT WHERE IN helpTompkins Neil21 Sep
  • Re: SELECT WHERE IN helpJohan De Meersman21 Sep
    • Re: SELECT WHERE IN helpTompkins Neil21 Sep
      • Re: SELECT WHERE IN helpJohan De Meersman21 Sep
        • Re: SELECT WHERE IN helpTompkins Neil21 Sep
          • RE: SELECT WHERE IN helpJerry Schwartz21 Sep
      • Re: SELECT WHERE IN helpMark Goodge21 Sep
  • Re: SELECT WHERE IN helpJoerg Bruehe21 Sep