<code> select f.name, d.name, b.abbr, b.question, (select validanswer.answer where validanswer.quest_id = b.quest_id and validanswer.is_inactive = 0), d.name from questlist as a inner join quest as b on a.quest_id = b.quest_id inner join pro as c on a.owner_id = c.pro_id inner join proname as d on c.proname_id = d.proname_id inner join resunit as e on c.resunit_id = e.resunit_id inner join loc as f on e. <\code>
I was hoping the nested select after b.question would return a list of results, as an element, but, of course, it didn't. Does anybody have any suggestions on how to get this to work?
Also, apparently the code tags no longer work, try phpbb style and html style, no tagging.
This post has been edited by modi123_1: 09 November 2012 - 08:19 AM
Reason for edit:: highlight the text and just click the code button