Re: group by
| From: | Francisco V. Romera | Date: | Tue, 14 Nov 2000 11:51:32 +0000 |
| Subject: | Re: group by | ||
| References: | 1 | Groups: | php.general.es |
| Request: | Send a blank email to general-es+get-3704@lists.php.net to get a copy of this message | ||
Por leyes del SQL debes poner en el GROUP BY todos los campos que te
aparecen en el SELECT, es decir:
SELECT descripcion,referencia,calle,precio,inmobiliaria
FROM vivienda
GROUP BY inmobiliaria,descripcion,referencia,calle,precio
Estos campos del group by con el orden de preferencia que quieres.
===================================================
Francisco V. Romera
E-Mail: al004027@anubis.uji.es
===================================================