Sorry I don't know what you mean by group name in a list. You will either need to use distinct, group by, or use the group by in ColdFusion when you use your outout tag. Not sure which is appropriate until you explain what you want the output to look like. Perhaps some example data may help
-----Original Message----- From: Andrew Scott [mailto:[EMAIL PROTECTED]] Sent: 13 February 2002 11:59 To: SQL Subject: Is it possible? Is it possible to be able to do the following, currently it returns a row for each record. Row_Return andrewcs groupname andrewcs groupname What I was hoping for is that it returned one row, but with the groupname in a list. Am I being too ambitious with my query! Here is the query SELECT og_Users.u_Username, og_GroupName.gn_Name FROM og_Users INNER JOIN og_UserGroup ON og_Users.u_ID = og_UserGroup.u_ID INNER JOIN og_GroupName ON og_UserGroup.gn_ID = og_GroupName.gn_ID ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
