Manlio Perillo ha scritto:
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?
Solved.
Just the way you expect it to work.
SQLAlchemy is really *the way* to build SQL statements.
Now I have only to understand how to use alias...
P.S.
What type of queries SQLAlchemy is not able to build?
Regards 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
-~----------~----~----~----~------~----~------~--~---
