Mysql Error no: 150

ERROR 1025 (HY000): Can't create table '.\database\#sql-1295_318.frm' (errno: 150).
We will encounter this problem typically when the tables have been created with different Engines

E.g one is of the type INNODB and the other is of the type MyISAM.