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
______________________________________________________________________
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
