Understanding LEFT JOIN

[Action-N]

I've run into a snag trying to use LEFT JOIN to cut out a query. I'm just a cut-n-paste coder so I can't figure this one out. I am after info from three tables, it's working now with two, but on the third it goes stupid on me. It only shows one listing with id's from seperate.

This is the working code with two tables:

$result_list = $DB_site->query("
SELECT vbgarage_users.*, user.username, user.usertitle
FROM " . TABLE_PREFIX . "vbgarage_users AS vbgarage_users
LEFT JOIN " . TABLE_PREFIX . "user ON vbgarage_users.userid = user.userid
ORDER BY user.username ASC
LIMIT $pos,$perpage
");


This is the query I want to add to it:

$result_image = $DB_site->query("
SELECT vbgarage_images.*
FROM " . TABLE_PREFIX . "vbgarage_images
WHERE vbgarage_images.userid = $list[userid]
ORDER BY vbgarage_images.imageid ASC
LIMIT 1
");


The image query works if I put it within the while of the $result_list, but doing it there appears to make a query for ever listing. If I could get help with this thanks, I'll keep reading my PHP books.

[Natch]

$result_list = $DB_site->query("
SELECT vbgarage_users.*, vbgarage_images.*, user.username, user.usertitle
FROM " . TABLE_PREFIX . "vbgarage_users AS vbgarage_users, " . TABLE_PREFIX . "vbgarage_images AS vbgarage_images
LEFT JOIN " . TABLE_PREFIX . "user ON vbgarage_users.userid = user.userid
WHERE vbgarage_images.userid = $list[userid]
ORDER BY user.username ASC, vbgarage_images.imageid ASC
LIMIT $pos,$perpage
");Does that work in your environment?