Re: including the result of one query in another query

[Brian V Bonini <b-bonini@xxxxxxx>]

On Sun, 2005-06-26 at 06:38, Pedro Quaresma de Almeida wrote:
> Hi
> 
> I have two databases, on for aeromodelistas (aeromodelling) and
> another for Códigos Postais (Postal Codes). I whant to do the
> following query
> 
> SELECT CódigoPostal FROM Aeromodelistas 
> WHERE CódigoPostal IN 
>   (SELECT distinct(CP4) FROM codigopostal.LOCART,codigopostal.DISTRITO
>    WHERE codigopostal.LOCART.DD=codigopostal.DISTRITO.DD 
>    AND   codigopostal.DISTRITO.DESIG='Coimbra'); 


I believer DISTINCT is not an SQL function, it's a statement.

SELECT DISTINCT column_name FROM table_name;

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php