Hi.
Is it possible to write something like:
SELECT name,
(SELECT max(pop)
FROM cities WHERE cities.state = states.name)
FROM states
The problem is how to setup up the where condition in the subquery: is
this possible?
Thanks Manlio Perillo
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---