Re: Subqueries or Joins? Problems with multiple table query - Mailing list pgsql-general

From Stefan Schwarzer
Subject Re: Subqueries or Joins? Problems with multiple table query
Date
Msg-id DED1D443-03B8-4B57-B9D5-F9389B39F1CC@grid.unep.ch
Whole thread Raw
In response to Re: Subqueries or Joins? Problems with multiple table query  (Thom Brown <thombrown@gmail.com>)
Responses Re: Subqueries or Joins? Problems with multiple table query  (Thom Brown <thombrown@gmail.com>)
List pgsql-general
> 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

pgsql-general by date:

Previous
From: Alban Hertroys
Date:
Subject: Re: pg_dump new version
Next
From: Thom Brown
Date:
Subject: Re: Subqueries or Joins? Problems with multiple table query