SELECT DISTINCT
countries.land,
CASE WHEN visits.trotterid='2'
THEN visits.trotterid
ELSE '0' end test
FROM countries
left JOIN visits
ON countries.landid=visits.landid
I have a website with a list of countries(countries.land)
Customer should after...
