I've tried using the following:
select * from TABLE1 where COLUMN= :VAR
union
select * from TABLE2 where COLUMN= :VAR;
I'm getting the following error message back:
[Teradata Database] [TeraJDBC 14.10.00.26] [Error 3654]
[SQLState HY000] Corresponding select-list expressions are incompatible.
If I just run:
select * from TABLE1 where COLUMN= :VAR;
then it works, but I need to be able to answer one prompt for the same variable that is used across multiple tables. I'm using Oracle SQL Developer Version 4.0.3.16
Best Answer
3654 Corresponding select-list expressions are incompatible.
The datatypes of the columns in
TABLE1
andTABLE2
do not match.