[RESOLVED] SQL query question

[Terminator]

Hello,

I am not sure how I can do this.

I have a table comments and a table users

On my website, visitors can leave a comment.
This can be guests or members.

My comments table has a userid field and a name field.

How can I get all comments for a specific ID where userid is linked to the users table. Normally you would do WHERE a.userid=b.id.
However some comments don't have a ID (NULL) and only has a name (for guests).

So what I seek is a SQL where I can all comments and the correct Userinformatie AND the guest names.

Any an idea ?

[johanafm]

SELECT * FROM comment LEFT JOIN user ON comment.user_id = user.id

And the * obviously needs to be replaced with what you actually want to get.

[Terminator]

Thanks, worked like a charme!