Avatar of cpwilson
cpwilson

asked on 

Problems with data join

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>
ColdFusion Language

Avatar of undefined
Last Comment
_agx_

8/22/2022 - Mon