oleg_evt1970Здравствуйте! Подскажите, пожалуйста, как решить след. проблему
Во View используется отдельный подзапрос типа

CREATE VIEW TEST AS

Select
invoice.in_number as Номер_Накладной,
......
(Select payments2.pm_sum0 from payments2
where payments2.pm_inkey = invoice.in_key and payments2.pm_kod=1) as НДС10

from invoice

WITH
CHECK OPTION;

При сохранении View возникает ошибка
Error Code: -383, SQL State: IX000] Need to specify view column names in the view definition.

В чем проблемы, как решить?

-383 Need to specify view column names in the view definition

In this VIEW statement, you have not listed specific names for columns. That action is allowed when the SELECT statement selects only simple, named columns. However, the SELECT statement here selects one or more expressions. You must give names to these columns in a parenthesized list that follows the name of the view. Because you cannot give names for only some of the columns, you must list names for all.