"Simplified", DOESN'T work: _________________________ SELECT responses.id, responses.category, answers0.description AS 29radio, answers1.description AS col88, answers2.description AS col89, answers3.description AS 32radio FROM responses, options LEFT JOIN answers AS answers0 ON responses.id = answers0.response AND answers0.option_id = options.id AND options.question = answers0.question AND options.question =29 LEFT JOIN answers AS answers1 ON responses.id = answers1.response AND answers1.option_id = "88" LEFT JOIN answers AS answers2 ON responses.id = answers2.response AND answers2.option_id = "89" LEFT JOIN answers AS answers3 ON responses.id = answers3.response AND ( answers3.option_id = "97" OR answers3.option_id = "98" OR answers3.option_id = "99" ) WHERE responses.inquiry =16 LIMIT 0 , 30 Works: _________________________ SELECT responses.id, responses.category, answers0.description AS 29radio, answers1.description AS col88, answers2.description AS col89, answers3.description AS 32radio FROM responses LEFT JOIN answers AS answers0 ON responses.id = answers0.response AND ( answers0.option_id = "90" OR answers0.option_id = "91" ) LEFT JOIN answers AS answers1 ON responses.id = answers1.response AND answers1.option_id = "88" LEFT JOIN answers AS answers2 ON responses.id = answers2.response AND answers2.option_id = "89" LEFT JOIN answers AS answers3 ON responses.id = answers3.response AND ( answers3.option_id = "97" OR answers3.option_id = "98" OR answers3.option_id = "99" ) WHERE responses.inquiry =16