01-15-2018 12:50 PM
I'm trying to do a left join with values of variables in the two tables in different cases. I am getting a error when trying to do the upcase in the where statement.
create table final as
select a.*, b.LBTO
from allx as a left lbx as b
on a.id=b.id where a.upcase(test)=b.upcase(test) and a.upcase(visit)=b.upcase(visit);
Need further help from the community? Please ask a new question.