RE: [PHP-ES] Resultado inexperado en consulta SQL
| From: | Christian Martiniera | Date: | Mon, 13 Nov 2000 17:49:55 +0000 |
| Subject: | RE: [PHP-ES] Resultado inexperado en consulta SQL | ||
| Groups: | php.general.es | ||
| Request: | Send a blank email to general-es+get-3681@lists.php.net to get a copy of this message | ||
EL sql ansi es
select * from tablas as alias asi que
prueba asi
SELECT a.id, a.nombre, p.nombre FROM asociacion as a, provincia as p, region
r,delegacion as d, delegado as dl WHERE dl.id=$id_delegado AND
d.id=dl.id_delegacion
AND r.id=d.id_region AND p.id_region=r.id AND a.id_provincia=p.id ORDER BY
p.nombre, a.nombre