The type of a FULL OUTER join's merged key, coalesce(left, right): their type when equal, else the most specific type both are, e.g. String for Varchar(15) and Varchar(2). The types must be compatible.
coalesce(left, right)
String
Varchar(15)
Varchar(2)
The type of a FULL OUTER join's merged key,
coalesce(left, right): their type when equal, else the most specific type both are, e.g.StringforVarchar(15)andVarchar(2). The types must be compatible.