No that is not what I want, I want one row. But when I use the User_Groups table I was hoping that the query could build a list in that field of groupnames.
-----Original Message----- From: John McCosker [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 13 February 2002 11:11 PM To: SQL Subject: RE: Is it possible? 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 . ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
