Re: Simple Query?

From: Rodrigo De León <rdeleonp(at)gmail(dot)com>
To: "Koen Bok" <koen(at)madebysofa(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Simple Query?
Date: 2007-09-11 21:46:17
Message-ID: a55915760709111446k78a7f254x65606ee2736959b@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On 9/11/07, Koen Bok <koen(at)madebysofa(dot)com> wrote:
> Anyone has a hint?

Another way:

SELECT i.*
FROM item i JOIN search_item s1 ON i.ID = s1.id_item
JOIN search_item s2 ON s1.id_item = s2.id_item
JOIN search_item s3 ON s2.id_item = s3.id_item
WHERE s1.id_search = 1
AND s2.id_search = 2
AND s3.id_search = 3

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Richard Broersma Jr 2007-09-11 21:59:37 Re: Simple Query?
Previous Message Koen Bok 2007-09-11 21:27:19 Simple Query?