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.docmsgid, > docs.sendername, DATE_FORMAT(docs.docdate, '%W %M %D %Y') as thedate, doctitle from >docs, > wdocid_pa where wdocid_pa.docid = docs.docid and docs.docdate > >FROM_UNIXTIME(975228544) > AND wdocid_pa.wordid=495 GROUP by docs.docid UNION ALL select count(docs.docid) as >score, > docs.docdate, docs.docid, docs.docsection, docs.docsubdir, docs.docmsgid, >docs.sendername, DATE_FORMAT > (docs.docdate, '%W %M %D %Y') as thedate, doctitle from docs, wdocid_ca where >wdocid_ca.docid = > docs.docid and docs.docdate > FROM_UNIXTIME(975228544) AND wdocid_ca.wordid=136 >GROUP by > docs.docid UNION ALL select count(docs.docid) as score, docs.docdate, docs.docid, >docs.docsection, > docs.docsubdir, docs.docmsgid, docs.sendername, DATE_FORMAT(docs.docdate, '%W %M %D >%Y') as thedate, > doctitle from docs, wdocid_bo where wdocid_bo.docid = docs.docid and docs.docdate > > FROM_UNIXTIME(975228544) AND wdocid_bo.wordid=1646 GROUP by docs.docid ORDER by >score DESC, > docdate DESC, docid DESC LIMIT 0, 10 > > > TIA > > Tony > What exactly does not work with query number 2 ??? Please explain in more detail. Also, upload your tables to ftp://support.mysql.com:/pub/mysql/secret tarred and gzipped and let me know a filename. -- Regards, __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php