Mike, patch works great for select. I haven't test it with insert/update though since I don't have permission on this DB. Here is the resulting query I see
SELECT * FROM cms_dbs_prod_global.primsummary WHERE cms_dbs_prod_global.primsummary.name IN (SELECT DISTINCT cms_dbs_prod_global.primarydataset.name AS cms_dbs_prod_global_prim_1 FROM cms_dbs_prod_global.processeddataset JOIN cms_dbs_prod_global.block ON cms_dbs_prod_global.processeddataset.id = cms_dbs_prod_global.block.dataset JOIN cms_dbs_prod_global.primarydataset ON cms_dbs_prod_global.processeddataset.primarydataset = cms_dbs_prod_global.primarydataset.id WHERE cms_dbs_prod_global.block.path LIKE :cms_dbs_prod_global_bloc_1) ORDER BY cms_dbs_prod_global.primsummary.name DESC and another one with aliases SELECT DISTINCT tblk.path AS tblk_path, tprd.creationdate AS tprd_creationdate FROM cms_dbs_prod_global.block tblk JOIN cms_dbs_prod_global.processeddataset tprd ON tblk.dataset = tprd.id WHERE tblk.numberofevents != :tblk_numberofevents_1 AND tblk.path IS NOT NULL ORDER BY tprd.creationdate DESC Valentin. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to [email protected] 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 -~----------~----~----~----~------~----~------~--~---
