Maybe I'm wrong here, but if you only want 1 row returned try this
SELECT TOP 1 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
J
.
.
-----Original Message-----
From: Andrew Scott [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 13, 2002 11:59 AM
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
______________________________________________________________________
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
