joining profile types using views module According to this thread, click here, I need to use relationships to inner join different content types.

I used the same method with profile types but I ended up with the following result.

Instead of using the views UI, do I need to custom code it?

Thanks
Currently it's creating a join for each relationship (each profile type) that's why you see several rows. Question is what would happen if a user has several profile types (can they have that)?

You might get by with putting Distinct on your query.

In Views, fold out Advanced and look for Query settings under Other. Choose settings and check Distinct. Hit save.