--- Mariusz <[EMAIL PROTECTED]> wrote:
> I would like to be able to select records from the a table where
> record_id and $record_id from my @record_ids matches. I know I could
> go through a loop and send a SELECT query for each element in the
> array but is there a better way? How can I accomplish the same but
> only sending one query?
Create a temp table with all the desired list items.
Then
select * from tab1, tmptab
where tab1.wanted_item = tmptab.wanted_item;
__________________________________________________
Do you Yahoo!?
U2 on LAUNCH - Exclusive greatest hits videos
http://launch.yahoo.com/u2
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
