can run mysql query again in View

[eluser]alaa007[/eluser]
for sure you can run a SQL query in the view, but this way you will break the rulesof the MVC who cares!
Why dont you create a new controller that get your request from that view and make the join and display the results in a new view?