Select countries.name, basel.year, basel.value, cites.year, cites.valueFrom countriesLeft Join basel on basel.id_country = countries.id_country and basel.value=1 Left Join cites on cites.id_country = countries.id_country and cites.value=1
I would have thought so, but the query turns forever.
smime.p7s
Description: S/MIME cryptographic signature