Strange problem: no output columns in the view definition or no items in the FROM clause

zjmzjmhuahua

I am trying to create a new view, but an error occurs, prompt: no output column in the view definition or no items in the FROM clause
code show as below:
SELECT id, num
FROM table1
WHERE num> 0
UNION ALL
SELECT id, qt as num
FROM table2
WHERE qt> 0

cv4bf5d65fd

There is no problem with the statement ~~~

我是杀人狂

Is there a problem with the condition? LZ query separately to see if there are results

fanfan1980

--try

create view VI
as
SELECT id, num
FROM table1
WHERE num> 0
UNION ALL
SELECT id, qt as num
FROM table2
WHERE qt> 0