Re: Re: Very complex query
| From: | Martin Marques | Date: | Thu, 11 Dec 2003 18:51:48 +0000 |
| Subject: | Re: Re: Very complex query | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-32001@lists.php.net to get a copy of this message | ||
El Jue 11 Dic 2003 05:17, Mike U. Petrov escribió:
> No, DISTINCT isn't match my purpose cause of it rerurns unique rows but I
> need ONE user_id per one object_id.
GROUP BY is your answer.
--
15:51:02 up 15 days, 22:07, 3 users, load average: 0.90, 0.75, 0.61
-----------------------------------------------------------------
Martín Marqués | select 'mmarques' || '@' || 'unl.edu.ar'
Centro de Telematica | DBA, Programador, Administrador
Universidad Nacional
del Litoral
-----------------------------------------------------------------