Multiple table relationanal query

[eluser]Unknown[/eluser]
Hello,
I'm very new to CI. I've been looking around for a multiple associated table example online and I cant find one. So my question is if I have two tables like so:

Code:

---------                    ------------
| USERS |                    | COMMENTS |
| ----- |                    | -------- |
| Id    |-------------------<| Users_Id |
| Name  |                    | Text     |
| Last  |                    ------------
---------

and we have a one to many relationship, where a user can have multiple comments.
whats the statement I have to use to get all the comments of a user given a name?

I'm a CakePHP guy, and I like the loosens of CI that's why I'm exploring CI and I like it so far.

[eluser]Future Webs[/eluser]
check the user guide for the database class and the join function

Code:

$this->db->join