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;