Re: problem with joining two tables

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