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,
I don't believe it's possible to do what you're suggesting. At least,
according to the second example on this page:
http://dev.mysql.com/doc/refman/5.1/en/subquery-errors.html.
-Travis
-Original Message-
From: Ramsey, Robert L [mailto:robert-ram...@uiowa.edu]
Sent: Monday, September 2
