When using SQLAlchemy SQL Expressions, what's the appropriate syntax
for doing a left join on a sub-query so that you can select results
from the sub-query and include them in the results for the main query
e.g.:
SELECT organization.name, email_address.email,
FROM organization
LEFT JOIN (
SELECT DISTINCT email.address AS email, organization.id AS org_id
FROM email, organization, organization_email
WHERE organization.id = organization_email.organization_id AND
email.id = organization_email.email_id
LIMIT 1
) email_address ON email_address.org_id = organization.id
-lcr
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
