SELECT `q`.`id` as `mainID`, `q`.`qgid`, `q`.`section`, `q`.`fieldType`, `a`.`qid`, `a`.`uid`, `a`.`answer` as `mainAnswer`, `sa`.`id`, `sa`.`answer`
FROM `gradlife_co_uk_-_gradlife`.`questions` as `q`, `gradlife_co_uk_-_gradlife`.`answers` as `a`, `gradlife_co_uk_-_gradlife`.`setanswers` as `sa`
INNER JOIN `gradlife_co_uk_-_gradlife`.`answers` ON `q`.`id` = `a`.`qid`
GROUP BY `q`.`id`, `a`.`uid` ORDER BY `a`.`uid`
051124 16:31:47 1 Query SELECT `q`.`id` as `mainID`, `q`.`qgid`, `q`.`section`, `q`.`fieldType`, `a`.`qid`, `a`.`uid`, `a`.`answer` as `mainAnswer`, `sa`.`id`, `sa`.`answer`
FROM `gradlife_co_uk_-_gradlife`.`questions` as `q`, `gradlife_co_uk_-_gradlife`.`answers` as `a`, `gradlife_co_uk_-_gradlife`.`setanswers` as `sa`
INNER JOIN `gradlife_co_uk_-_gradlife`.`answers` ON `q`.`id` = `a`.`qid`
GROUP BY `q`.`id`, `a`.`uid` ORDER BY `a`.`uid`
C:\Program Files\MySQL\MySQL Server 4.1\bin\mysqld-nt, Version: 4.1.10-nt-log. started with:
TCP Port: 3306, Named Pipe: MySQL