JOIN Quistion

[eluser]bgreene[/eluser]
have you tried
select a.*, i.whatever from alinea a
left join image_koppel k on k.id = a.alinea_id
left join image i on i.id = k.image_id
where (a.pagina_id = 1) and (a.alinea_status = 1)
order by a.alinea_volgorde asc