> As you can see the from_obj of subselect is wrong, the FROM should be: > > FROM azienda_veterinario, unita_aziendale
OK, I see... You probably mean that since your sub-select occurs on two tables, those have to be present in the FROM clause. I've tested this kind on query (select a from A where a in (select b from B where a = b)) and this works ok (MySQL). Your sub-query becomes invalid if taken alone, but the whole keeps correct. What's the error when performing manually the query (using mysql client or the like) ? Seb -- Sébastien LELONG sebastien.lelong[sirloon.net] http://www.sirloon.net --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---