i want my table output to work like so....
a department (department.name)
- category in this department (categories .name)
- another category in this department (categories .name)
but the isses i have (i think) is that they are both called name
i have this so far...
SELECT d.name, d.depId, d.pos, c.name, c.catId
FROM departments d
INNER JOIN categories c
ON c.depId = d.depId
ORDER BY d.pos
<cfoutput query="ArtCategories" group="name">