The intermediate result table is the result of the view or common table expression. If the view-name references a typed view, the intermediate result table is the UNION ALL of the view with all its subviews, with only the columns of the view-name
Navigate to the following pages to get more details about the translation spec for the subsections of the View Reference grammar.