Michel Di Croci <[email protected]> wrote:
> I'm in the same situation as this person,
> 
> http://www.mail-archive.com/[email protected]/msg08106.html
> 
> I would like to know if it's feasible to user column alias in the same
> query...

Only via a subselect. Something like this:

select some-expr(alias1, alias2) from (
  select expr1 alias1, expr2 alias2 from ... where ...
);

-- 
Igor Tandetnik

_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to