have 2 queries that work singularly but errors out when used as a UNION of the 2 sqls, query errors
I have 2 queries that work beautifully when ran individually but when I create a UNION of the 2 queries I run into issues.
I am trying to list out hours detail for PL accrual routine and can run each of the sqls individually and I get the correct information. But in order to get the total information, I need to run a union of the 2 queries (see below). The only fields that do not have the same data types are peev.screen_entry_value (VARCHAR2) and det.value which is numeric. I tried different ways to convert the VARCHAR2 field in the sql but not successful in any of my attempts (using To_NUMBER or CAST) .