Combine queries for Insert and Select always obeys Innodb locking rulesif one of the source table is based on Innodb engine.It is also possible that the INSERT activity applicable to TEMPORARYtable which is not InnoDB engine. It is also possible that in SELECTsection with INNODB, some other TEMPORARY Tables are used.Devang Modi