Multiple join question

[eluser]bubbafoley[/eluser]
your select is wrong

Code:

$this->db->select('p.*, SUM(r.product_price) as revenue, b.*');