Avatar of 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
<cfoutput query='get_problems'>
ColdFusion Language

Avatar of undefined
Last Comment

8/22/2022 - Mon