I am trying to do an inner join in an open query (Oracle) where both join fields are numeric, but it returns zero results when I can see that there are matches between the two tables.
One table has almost 1 million records and the other has only 678. I'd hate to use a left outer join as it takes too long and gives me unwanted records/results.
"inner join on isnumeric(b.EMPL_NO) = isnumeric(a.emplid)"
How can I solve this?