Simple SQL question from a beginner...

[eluser]Aken[/eluser]
I would use two separate queries. As that stands, you're going to have a lot of redundant profile data.

In my model, I would create three functions:

1) A function to pull the individual profiles.
2) A function to pull all category info associated with a given profile ID.
3) A function that uses the two previous functions and creates an array or object that is organized and ready for easy displaying in your view. It would call #1, loop it, call #2 for each profile, and generate the data.