Whats wrong with this SQL?
Posted: Thu Nov 24, 2005 10:36 am
Okay,
This SQL query causes the server to crash...tried it on 3 different servers, all with the same effect.
Any ideas?
This SQL query causes the server to crash...tried it on 3 different servers, all with the same effect.
Code: Select all
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`Any ideas?