Re: MySQL 4 UNION problem

2001-11-26 Thread Sinisa Milivojevic
Tony Bailey writes: > I've been trying MySQL 4 alpha (Windows build) as I need UNION but can't work out >how to get the query I > need against the version without the union > [skip] > 2) > select count(docs.docid) as score, docs.docdate, docs.docid, docs.docsection, >docs.docsubdir, docs.docm

MySQL 4 UNION problem

2001-11-26 Thread Tony Bailey
I've been trying MySQL 4 alpha (Windows build) as I need UNION but can't work out how to get the query I need against the version without the union Seems I need a sub select but that's not supported yet. I'm trying to get a score of a search result - the first query works as required (but pot