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 =...
I'm trying to retrieve a value in a table column but I need it filtered by column values from two tables. Can I use custom business view to perform the queries using C++ business function ?
I want to return the value of F43C30.ADUKID from joining F43C30.ADUKID = F43C40.ADUKID based on...