List:General Discussion« Previous MessageNext Message »
From:Tompkins Neil Date:September 21 2010 3:44pm
Subject:Re: SELECT WHERE IN help
View as plain text  
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 ?

Cheers
Neil

On Tue, Sep 21, 2010 at 4:40 PM, Johan De Meersman <vegivamp@stripped>wrote:

> If there are two, you will return two.
>
>
> On Tue, Sep 21, 2010 at 5:33 PM, Tompkins Neil <
> neil.tompkins@stripped> wrote:
>
>> Hi
>>
>> With a SELECT * FROM my_table WHERE record_id IN (3,4,5,6,7,3), how can I
>> return two records for the record_id 3 ?  Is it possible ?
>>
>> Cheers
>> Neil
>>
>
>
>
> --
> Bier met grenadyn
> Is als mosterd by den wyn
> Sy die't drinkt, is eene kwezel
> Hy die't drinkt, is ras een ezel
>

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