phaseId | phaseName | milestoneId | milestoneName
--------------------------------------------------
1 phase1 1 name1
1 phase1 2 name2
1 phase1 3 name3
2 phase2 4 name4
2 phase2 5 name5
2 phase2 6 name6
3 phase3 7 name7
3 phase3 8 name8
3 phase3 9 name9
I am trying to output the query so that in a table I can get the output to
look like:
Phase1
---name1
---name2
---name3
Phase2
---name4
---name5
---name6
Phase3
---name7
---name8
---name9
The query I am using is as follows:
SELECT
P.phaseId,
P.phaseName,
M.milestoneId,
M.nilestoneName
FROM
milestone M
INNER JOIN phase P ON (M.milestonePhaseId = P.phaseId)
ORDER BY
P.phaseName
How do I setup the cfoutput tags with the query and group attributes set to
obtain the output I described above..
Thanks!
Mike
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
