创建视图包含以下语句报错Column 'num' in field list is ambiguous.

[zmix999]

描述
对问题简单清晰的描述
创建视图包含以下语句报错
(
select
*
from
test
where
id in (
SELECT
max(id)
FROM
test
where
num is not null
group by
num
)
)