In the last episode (Dec 07), Renato Lins said:
> Mysql Version 3.20.17 Sun Spac Station
>
> this is the query
>
> SELECT RData as Data, Hora, Ramal, Linha, ACC , 002_central.numero as
> 'No Discado', 002_agenda.nome as 'Destinatario', TR,
> sec_to_time(duracao) as 'Duracao', Sigla , Servico as 'Servico',
> Operadora , 002_central.DDD , DDI , Item from 002_central left join
> 002_numeros on 002_central.numero=002_numeros.fone left join
> 002_agenda on 002_numeros.id=002_agenda.id
>
> parse error near 'Data
>
> I think, in this version column alias is not supported, could some
> one confirm that ??
Aliases are supported (you would get a parse error near 'as' if that
were the case). Your problem is that DATA is a reserved word. Try
SELECT Rdata as 'Data', ......
instead.
--
Dan Nelson
dnelson@stripped
