Posted by Brian V Bonini on 06/26/05 14:53

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;

• Next in forum: Re: css/html expertise??
• Prev in forum: Re: [PHP] including the result of one query in another query
• Thread view: Re: [PHP] including the result of one query in another query

[Reply to this message]