On 9/27/2010 9:10 AM, Ramsey, Robert L wrote:
I have a query with three subselects, all referencing the same table. I'd like
to be able to combine them into one with aliases.
Here's what I have now:
select letter_codename,
(select greek from letter_otherlanguages where letter ='A') as greek,
nday, September 27, 2010 7:10 AM
To: [MySQL]
Subject: multiple aliases
I have a query with three subselects, all referencing the same table. I'd
like to be able to combine them into one with aliases.
Here's what I have now:
select letter_codename,
(select greek from letter_otherlangua
I have a query with three subselects, all referencing the same table. I'd like
to be able to combine them into one with aliases.
Here's what I have now:
select letter_codename,
(select greek from letter_otherlanguages where letter ='A') as greek,
(select french from letter_otherlanguages where
