SELECT @statement := CONCAT('INSERT INTO joomla.jos_vm_product SELECT ', GROUP_CONCAT(
	SELECT 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"
		)
), ' FROM mambo.mos_pshop_product');

PREPARE myStatement FROM @statement;
EXECUTE myStatement;
DEALLOCATE PREPARE myStatement;