[rh71]

MS SQL db table "BLAH":

Item - UserMain - UserAlt
whistle - john@test.com - barry@test.com
keys - larry@test.com - ted@test.com
clock - ted@test.com - cory@test.com
phone - john@test.com - zack@test.com
radio - john@test.com - cory@test.com
candy - larry@test.com - john@test.com

Having trouble figuring out how to output to 2 columns, distinct users with the items they are attached to...
USER - ITEMS
john@test.com - whistle phone radio candy
barry@test.com - whistle
larry@test.com - keys candy
ted@test.com - keys clock
cory@test.com - clock radio
zack@test.com - phone

I would then use ColdFusion to email each user individually with the items they're responsible for (but that's pretty straightforward from there). I have also been toying with doing all of it in CF (arrays) but that isn't exactly working out either. Any guidance appreciated.

[OBP]

Well I don't know much about SQL databases, only Access. One way to do this would be to use a Temporary Table which has the UserName and Items, then use an Update query to add each Item to the Items field first for the UserMain and then for the UserAlt.
Or you could use a VBA Recordset to do the same thing, including creating the email, depending on which email program you use.