SQL rename not working in lazarus lazarus / 13-General ---------------------------------------------------------------------- Neojag · 2008-05-05 20:34 I have lazarus running the following query (on a postresql database): SELECT data, detalhes, delito.descricao as delito,punicao.descricao as punicao,gravidade FROM praticou join delito on praticou.tipo_delito=delito.tipo join punicao on punicao.tipo=praticou.tipo_punicao WHERE bi_aluno=132123548 and data=to_date('10-12-1998','dd-mm-yyyy') This works fine anywhere else, but when I use it within lazarus  the 'delito' and 'descricao' rows are not recognized. Any idea why? Thanks