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
