Skip to Content
0
Jan 03, 2019 at 05:25 AM

In SELECT can we use to Uppercase in ON condition of INNER/LEFT OUTER JOIN

1030 Views Last edit Jan 03, 2019 at 05:27 AM 2 rev

Hi All,

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.