I'm trying to select multiple tables and want to display them as if they belong together.
I have 3 tables; users, profile and comment.  

The table users has the following rows; id, name, password.  

profile; id, userid, bio, website.  

comments; id, userid, comment, date.

The id of the users table is the same as the userid from profile and comments. I want to show all of the results, but ordered, so the comment and profile information from that user, are shown with that user, example;

```
Username: Mister Noname
Bio: 25 years old
Website: http://google.com
Comments: Bla bla bla!!

Username: Jay Wit
Bio: 99 years old
Website: http://stackoverflow.com
Comments: Best website ever!

```

I tried using JOIN, but can't seem to get it to work right, can someone help me out?  

Thanks in advance.