Trying to join tables to display the author of blog entry

[eluser]missionsix[/eluser]
well, since i'm not an active record db guy, i'll just give you the sql used:

Code:

$SQL = "SELECT blog_entries.*, users.* FROM blog_entries
LEFT JOIN users ON (blog_entries.author_id = users.user_id) WHERE
blog_entries.id = {$blog_entry_id}";

I hope you know how to read SQl. The two tables are blog_entries & users, i think you can figure it out though.