Hey gang -
I'm digging around in the Books Online bit for SQL7 and can't seem to figure
this out...
I've got a query, with about four tables it, all joined. No biggie. One of
the fields causes the recordset to be more-than-one - one of the tables is a
"user" table, but on the other end of the join is a "permissions" sort of
table, with a one-to-many relationship.
What I'm trying to do is get the permissions-related field's contents to
come back as a single record, so instead of
User Perm
1 1
1 2
1 3
I get
User Perm
1 1,2,3
Is there SQL syntax to do this?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
