Can we use kind of Translate word in ON of INNER/LEFT OUTER JOIN? Like TABLE A columns 1 2 3 4 and TABLE B columns 3 4 5 6. 3 is case sensitive in Table A and uppercased in Table B. Can we use like below? I do not want to use this condition in WHERE clause because I need data of table A though there is no data in table B, so trying to use in ON condition. Please guide..
Select a~1, a~2, a~3, a~4, b~5, b~6 from A left outer join B ON ( b~3 eq upper(a~3) and b~4 eq a~4 ) into table @data(c) where 5 = @lc_rv.