concat

I have a query that gets rows from a double join in the same table, with different criteria. This is the join: SELECT ... FROM F5547006 LEFT JOIN F03B11 B11A ON B11A.RPVR01 = 'B'||TAVR02 OR B11A.RPVR01 = 'R'||TAVR02 LEFT JOIN F03B11 B11B ON B11B.RPVR01 = 'B'||TAVR01 OR B11B.RPVR01 =...