Re: Subqueries or Joins? Problems with multiple table query

[Stefan Schwarzer <stefan.schwarzer@xxxxxxxxxxxx>]

> 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.

<<attachment: smime.p7s>>