MySQL Forums
Forum List  »  Newbie

Re: select ... where ... in(select ..)
Posted by: Felix Geerinckx
Date: August 12, 2005 02:19AM

Majdi Swais wrote:

> I'm trying to execute the following query "select f1,f2 from table1 where f2 in (select f3
> from table2 where ...)"

Could you post the full query, together with the output of

EXPLAIN SELECT ...\G ?

--
felix
Please use BBCode to format your messages in this forum.

Options: ReplyQuote


Subject
Written By
Posted
Re: select ... where ... in(select ..)
August 12, 2005 02:19AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.