[KCFusion] SQL help

[Adaryl Wakefield]

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