db table joining issue? or, is there a better way?

[eluser]FireMe[/eluser]
Thanks for the reply CroNiX so the best way to do it would be.

Code:

$this->db->select('quotes.id,
                   quotes.user_id,
                   quotes.file_id,
                   quotes.restore_type,
                   quotes.status,
                   quotes.price,
                   quotes.product_type,
                   file.id as f_id,
                   file.path,
                   file.user_id as f_user_id');