Unanswered: Is the following possible through SQL?
on a car renting company program, I have 3 tables, Persons, Cars, PersonRentsCar
Persons - Cars is obviously a m:n relation.
What I want to get is a Grid containing only once every name and in separate cells the cars he/she has already rented, something like:
Person1 Car1 Car3 Car34
Person3 Car2 Car3 Car23
Person17 Car 2 Car7 Car34 Car56
I think that this is impossible through SQL. But, is there maybe a way through a function to do that? Or does it need an extern programme, which will get and sort the data in a List or Array?
I am almost convinced that I need a separate small utility to do the job, but I wanted to ask here, in case someone has a better idea.