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.
Subject
Written By
Posted
February 12, 2010 06:25AM
February 12, 2010 10:05AM
February 12, 2010 12:45PM
February 13, 2010 01:19PM
February 13, 2010 02:01AM
Re: Need help with a more difficult query
February 14, 2010 01:23AM
February 13, 2010 10:12AM
February 13, 2010 12:55PM
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.