• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!


  1. F

    Complex Join using 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 =...