List:General Discussion« Previous MessageNext Message »
From:Tompkins Neil Date:September 21 2010 3:47pm
Subject:Re: SELECT WHERE IN help
View as plain text  
Thanks for the reply.  The search of  (3,4,5,6,7,3)  is pulling data from a
table.  I think in this case I need to change my design .

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

> I don't think that'll work, no. Why would you want to return duplicate data
> ? The whole point of an RDBMS is to *avoid* duplicate data :-)
>
>
> On Tue, Sep 21, 2010 at 5:44 PM, Tompkins Neil <
> neil.tompkins@stripped> 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 ?
>>
>> 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
>>>
>>
>>
>
>
> --
> 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