Off topic, but just in case anyone can help..
I dont know what such a requirement would be called, so Im struggling to search online for a meaningful answer
I have several tables, with one-to-many joins
These aren't real columns or fields, but I have a requirement from a customer who doesnt understand the nature of joins, cartesian joins and so on, who feels that,
despite Person1 having several attributes AND several nicknames
They want a dataset with one row per person
If I join these together into a single row of data, obviously I get 4 rows for Person1 .. as many rows as Attribute * Nickname in the contrived example above.
Max() isnt acceptable.
So what I am wondering is :
Is there a SQL method of taking
Person1/ Attribute 2 , Attribute 3
in order that I can put all Attributes (however many there are) into a single column.
Like a pivot table, but without turning rows into many columns, just one