List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:December 7 1999 11:17pm
Subject:Re: What Is Wrong with this
View as plain text  
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
Thread
What Is Wrong with thisRenato Lins8 Dec
  • Re: What Is Wrong with thisDan Nelson8 Dec
  • size of computationLucas Gonze10 Dec