query werkend krijgen met join

[roben]

Kan iemand mij vertellen waarom deze query het niet doet,

SELECT DISTNCT t.type_id, t.photo AS photo, t.type_id AS typeid, t.name AS type, b.name AS brand 
FROM types t, brands b LEFT JOIN reviews r ON t.type_id = r.type_id_fk 
WHERE t.brand_id_fk = b.brand_id $brandsresult AND $merken t.status LIKE '1' 
AND b.top LIKE '1' AND b.status LIKE '1' ORDER BY b.name ASC

en deze wel?

SELECT DISTNCT t.type_id, t.photo AS photo, t.type_id AS typeid, t.name AS type, b.name AS brand 
FROM types t, brands b  
WHERE t.brand_id_fk = b.brand_id $brandsresult AND $merken t.status LIKE '1'
AND b.top LIKE '1' AND b.status LIKE '1' ORDER BY b.name ASC

en deze ook?

SELECT DISTINCT t.type_id, t.name AS type, t.photo AS typephoto, b.* 
FROM brands b, types t LEFT JOIN reviews r ON t.type_id = r.type_id_fk 
WHERE t.brand_id_fk = b.brand_id AND b.status = 1 AND t.photo <> '' 
AND t.status = 1 " . $sExtraProducts . " ORDER BY r.select3 DESC LIMIT 1

 

[Epic]

Komt door deze regel:[sql]FROM types t, brands b LEFT JOIN reviews r ON t.type_id = r.type_id_fk[/sql]

De volgorde van tabellen klopt niet, je moet de 2 tabellen die je wilt joinen achter elkaar zetten:[sql]FROM brands b, types t LEFT JOIN reviews r ON t.type_id = r.type_id_fk[/sql]

 

[roben]

haha, daar had ik nooit opgekomen..! heel erg bedank, dit scheelt weer een hoop gedoe..!