Re: problem with joining two tables - Mailing list pgsql-novice

From Nabil Sayegh
Subject Re: problem with joining two tables
Date
Msg-id 20010521102751.C706C14EE63@gerstung3.net-lab.net
Whole thread Raw
In response to problem with joining two tables  ("Giorgio A." <jh@libero.it>)
List pgsql-novice
On 21 May 2001 12:15:21 +0200, Giorgio A. wrote:
> well, but when a content has more than one 'date' i get the same content
> repeated for the number of its dates... this is not what i want to retrieve
> ! i want to do a SELECT which gives me only one occurance for each content,
> even when the content has more than one date of happening ! I tried


Sounds very confusing to me. You want only one result, NO MATTER WHICH ?
That doesn't make sense. Hm, perhaps you want to GROUP, ORDER and LIMIT
1 ?
You should draw some example tables, and an example result, so we better
understand
what  you want to achieve.

--

 Nabil Sayegh



pgsql-novice by date:

Previous
From: "Giorgio A."
Date:
Subject: problem with joining two tables
Next
From: "Bill Howell"
Date:
Subject: Re: problem with joining two tables