| From: | Nabil Sayegh <nsmail(at)sayegh(dot)de> |
|---|---|
| To: | Giorgio "A(dot)" <jh(at)libero(dot)it> |
| Cc: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: problem with joining two tables |
| Date: | 2001-05-21 10:31:16 |
| Message-ID: | 20010521102751.C706C14EE63@gerstung3.net-lab.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bill Howell | 2001-05-21 13:50:24 | Re: problem with joining two tables |
| Previous Message | Giorgio A. | 2001-05-21 10:15:21 | problem with joining two tables |