A query in multiple tables

[eluser]earlyriser[/eluser]
It works now. Thanks for your help guys. The final code is:

Code:

$this->db->select('w.name, wc.rating');
$this->db->from('wines w');
$this->db->where('user_id', getUserProperty('id'));
$this->db->join('wine_comments wc','w.id = wc.wine_id');

$data['query']= $this->db->get();
$this->load->view('wine_comment.php', $data);