SELECT @fieldList := 
	SELECT 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;