Postgres Pro
Downloads
Home   >   mailing lists

Re: Simple Query? - Mailing list pgsql-sql

From Rodrigo De León
Subject Re: Simple Query?
Date
Msg-id a55915760709111446k78a7f254x65606ee2736959b@mail.gmail.com
Whole thread Raw
In response to Simple Query?  (Koen Bok <koen@madebysofa.com>)
List pgsql-sql
Tree view 
On 9/11/07, Koen Bok <koen@madebysofa.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_itemWHERE s1.id_search = 1  AND s2.id_search = 2  AND s3.id_search = 3

pgsql-sql by date:

Previous
From: Koen Bok
Date:
Subject: Simple Query?
Next
From: Richard Broersma Jr
Date:
Subject: Re: Simple Query?