Re: Subqueries or Joins? Problems with multiple table query

From: Stefan Schwarzer <stefan(dot)schwarzer(at)grid(dot)unep(dot)ch>
To: Thom Brown <thombrown(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Subqueries or Joins? Problems with multiple table query
Date: 2010-02-23 13:23:25
Message-ID: DED1D443-03B8-4B57-B9D5-F9389B39F1CC@grid.unep.ch
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thom Brown 2010-02-23 13:28:24 Re: Subqueries or Joins? Problems with multiple table query
Previous Message Alban Hertroys 2010-02-23 12:21:41 Re: pg_dump new version