Re: [GENERAL] Subqueries or Joins? Problems with multiple table query

[Stefan Schwarzer]

Select countries.name, basel.year, basel.value, cites.year, cites.value

From countries

Left 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