Error 162

Message text

Cannot outer join a view with a UNION or GROUP BY

Item

Value

SQLCode

-162

Constant

SQLE_CANNOT_OUTER_JOIN

SQLState

52W19

ODBC State

42000

Probable cause

A view that contains a UNION or view cannot be used on the right of a LEFT OUTER JOIN or on the left of a RIGHT OUTER JOIN.