MySQL Forums
Forum List  »  Newbie

Re: Need help with a more difficult query
Posted by: Rob Grubb
Date: February 14, 2010 01:23AM

thanks for everyone's input and extra thanks to Rick, this is exactly the query i need. Cheers mate

Ps: i also found that multiple sub queries will solve the problem also but with slightly slower fetch times.

SELECT * FROM broker
where broker.broker in (
select broker from broker_type
where typeid='4') and broker.brokerin(
select broker from broker_market
where marketid='3');



Edited 1 time(s). Last edit at 02/14/2010 01:27AM by Rob Grubb.

Options: ReplyQuote


Subject
Written By
Posted
Re: Need help with a more difficult query
February 14, 2010 01:23AM


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.