Having problems with output from table join. Have 2 tables with a shared field (typeid) but when outputing only shows 1 record from the primary table. Code being used is as follows
<cfquery name="get_problems" datasource='#conn#'>
SELECT w.typeid, w.problem_type, c.typeid, c.problem_area
FROM problem_types w
INNER JOIN problem_areas c
ON w.typeid=c.typeid
ORDER BY w.problem_type ASC
</cfquery>
<cfoutput query='get_problems'>
#problem_type#<br>
<ul>
<cfoutput>
<li>#problem_area#</li>
</cfoutput>
</ul>
</cfoutput>