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.tompk...@googlemail.com > 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 <vegiv...@tuxera.be>wrote: > >> If there are two, you will return two. >> >> >> On Tue, Sep 21, 2010 at 5:33 PM, Tompkins Neil < >> neil.tompk...@googlemail.com> 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
