RE: [KCFusion] SQL help

[Benjamin Price]

Title: Message

Try this: <cfoutput query="queryname" group="topicID"> #topicName#     <cfoutput>         #unitName#     </cfoutput> </cfoutput>   I love the group attribute, it comes in very handy sometimes. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Adaryl Wakefield Sent: Thursday, January 22, 2004 12:09 PM To: [EMAIL PROTECTED] Subject: [KCFusion] SQL help This has been kicking my ass all morning and IM sure the solution is simple. I have two tables topics(topicID, moduleID, topicName) units(unitID, topicID, unitName)   So far ive got: SELECT topics.topicID, topics.topicName, units.unitID, units.unitName FROM topics, units WHERE topics.topicID *= units.topicID AND topics.moduleID = 2   And I need the output to look like   topicName     unitName     unitName     unitName topicName topicName topicName   Its the output that Im hung up on. The query returns 9, Introduction, 2, Unit 1 9, Introduction, 3, Unit 2 9, Introduction, 6, Unit 3 10, S of Star, Null, Null 11, T of Star, Null, Null 12, A of Star, Null, Null 13 R of Star, Null, Null   And I have no clue how to spit that out right.   Adaryl "Did you reboot?" Wakefield Aviator by passion Programmer by sheer force of will