Can't get update one prompt for same variable over multiple tables
3654   Corresponding select-list expressions are incompatible.


  Explanation:
  
  If a query contains a UNION, MINUS, or INTERSECT operator, then the
  data types for all select-list expressions must be compatible with the
  corresponding expression in the select-list for the first SELECT in
  the query. All numeric data types are considered compatible. Character
  data types are not compatible with numeric data types. Byte data types
  are only compatible with byte data types. Graphic data types are only
  compatible with graphic data types.


The datatypes of the columns in TABLE1 and TABLE2 do not match.