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]

[sql]$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
");[/sql]Does that work in your environment?