>I started out that way, but couldn't make a join of any type work... > >I tried left join, inner join, join, union, etc, but the best I could do >was get one title with one section. There should be one title with >multiple sections.
Rick, 1. I would remove the * and reference your fieldnames. 2. Remove that group by n the SQL. 3. Your query output should look something like this: <cfoutput query="getStuff" group="theTitleFieldHere"> <h1>#someTitleField#</h1> <cfoutput> <p>#theDetailField#</p> </cfoutput> </cfoutput> See if that works. Will ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322853 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4