Using model functions in View

[eluser]daparky[/eluser]
Thanks for your reply Zorancho. I tried a left join, i was querying the client table and joining the domains table in where client.id = domain.client_id. I was having issues doing it this way because of duplicate results.

What was happening was that depending on how many domains the client had, the result of that client kept repeating until the number of domains reached. For example:-

Client 1 has ten domains
The loop repeated Client 1 ten times, each object had the different domain in.

What i wanted to achieve (i achieved this using the above method) was listing all clients, displaying info from the client table and then going into the domain table and getting all the domains the client holds.