Re: Alias name from subquery

On 30/09/2008 14:21, Felix Homann wrote:


> I would like to set an alias name for a column from a subquery, i.e.
> something like this:
>
> SELECT entry AS (SELECT name from colnames WHERE id=1) from entries ;


select entry from (select name from colnames where id = 1) as
entry_with_different_name;

...maybe?

Ray.

------------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod@iol.ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------