get value from views and send it directly to model

[eluser]rochellecanale[/eluser]
Try to execute traditional query.

Code:

$sql = "SELECT * FROM member
           RIGHT JOIN sales ON member.id = sales.id";