MySQL Forums
Forum List  »  Newbie

how to construct a query based on results of a previous query
Posted by: Rob Henderson
Date: July 20, 2005 09:29AM

As a complete novice to mysql I have taken the cowards route and am using the mysql query browser to interrogate our institution's database. So far I have managed to construct one query which gives me all individuals that have one of three titles.

based on this I now want to find all the individuals that are affiliated to those listed in the first query.

the first results table looks something like this
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
subject id : name : title : groupid :
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
I want to be able to find all individuals with the same groupid as those found by the first query but who don't a title.

I'm not sure if that makes any sense - all help would be most appreciated - and if it is doable from within mysql query browser so much the better!

thankyou

Options: ReplyQuote


Subject
Written By
Posted
how to construct a query based on results of a previous query
July 20, 2005 09:29AM


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.