You should probably use "union all" here. Make it a habbit to use that by default and only use "union" if needed.
Eddie Awad
· 3 years ago
Anders, thanks for the good and valid tip. For the purpose of demonstrating datatype incompatibilities using only the dual table, "union" should be ok here.
All Comments
You should probably use "union all" here. Make it a habbit to use that by default and only use "union" if needed.
Anders, thanks for the good and valid tip. For the purpose of demonstrating datatype incompatibilities using only the dual table, "union" should be ok here.