Re: [vox-tech] MySQL 3.x subqueries question

2004-01-02 Thread David Hummel
On Fri, Jan 02, 2004 at 08:12:27PM -0800, David Siedband wrote: > I have two SQL queries that I'm trying to combine using subqueries. [snip] > FWIW, I'm using MySQL 3.23 You need at least MySQL 4.1 for subqueries. > [Parent] > select distinct Hypoth.ID , Hypoth.ShortName , Hypoth.Priority > from

[vox-tech] MySQL 3.x subqueries question

2004-01-02 Thread David Siedband
I have two SQL queries that I'm trying to combine using subqueries. These are part of a web app lets people vote on the relative importance of a bunch of hypotheses The one that will be the parent query gets all the hypotheses in a selected category. The query that I'd like to make the subquer