[Resolved] [Resolved] I found it

[gvanaco]

$queryselection = "landen.land_id , landen.land_naam ,landen.land_continent ,landen.land_status ,landen.land_link ,t2.Cot_opm ,t3.Cot_opm ";

$query = "SELECT $queryselection FROM landen LEFT JOIN Cot AS t2 ON landen.graadtech = t2.Cot_id LEFT JOIN Cot AS t3 ON landen.graadboul = t3.Cot_id ORDER BY land_naam";

I need the join and this is the result

Thanks for all your help