What I need to do, I could do easily in PHP, but unsure how to do it in SQL...
we have a list of users and a list of customers... Some users may be tied to multiple customers
I need to run a report that would look like the following:
Cust1, Cust3, Cust7 John Doe
Cust2 Jane Doesn't
Cust1, Cust3, Cust5 Joe Schmoe
I know how to make a list that puts each customer on it's own line, but I need to shrink them up so that it is one line per user with all the customers in the same cell...
The fields are: Users.UsersID, Users.FirstName, Users.LastName
Is there a way to do this?
View Complete Post