创建视图包含以下语句报错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 ) )