join business view

  1. 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 =...
  2. Can I use custom join business view in C++ business function

    Hi, 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...