SELECT @fieldList := GROUP_CONCAT(column_name)FROM information_schema.columns WHERE table_schema="joomla" AND table_name = "jos_vm_product" AND column_name IN ( SELECT column_name FROM information_schema.columns WHERE table_schema="mambo" AND table_name = "mos_pshop_product" );SELECT @statement := CONCAT( 'INSERT INTO joomla.jos_vm_product (', @fieldList, ') SELECT ', @fieldList, ' FROM mambo.mos_pshop_product');PREPARE myStatement FROM @statement;EXECUTE myStatement;DEALLOCATE PREPARE myStatement;