MySQL Forums
Forum List  »  Newbie

Re: Need help with a more difficult query
Posted by: Rick James
Date: February 13, 2010 02:01AM

SELECT b.*
   FROM broker b
   JOIN broker_market bm ON bm.broker = b.broker
   JOIN broker_type   bt ON bt.broker = b.broker
   WHERE  bm.marketid = 2
     AND  bt.typeid = 4;

Options: ReplyQuote


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


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.