Re: Subqueries or Joins? Problems with multiple table query

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