Inv3go

SELECT o.id, c.country_name as load_country,c1.country_name as unload_country FROM `orderdetails` as o LEFT JOIN `countries` as  c ON o.load_country_id = c.id
LEFT JOIN `countries`  as c1 ON o.unload_country_id = c1.id;

SELECT o.id, c.country_name as load_country,c1.country_name as unload_county,ci.city_name as load_city,ci1.city_name AS unload_city FROM `orderdetails` as o 
LEFT JOIN `countries` as  c ON o.load_country_id = c.id
LEFT JOIN `countries`  as c1 ON o.unload_country_id = c1.id
LEFT JOIN `cities` as ci ON o.load_city_id = ci.id
LEFT JOIN `cities` as ci1 ON o.unload_city_id = ci1.id;