Join a Table

def qapi = api.queryApi()

def p = qapi.tables().products()
def c = qapi.tables().productExtensionRows("Costs")

def today = new Date()

return qapi.source(p, [p.sku(), p.label], p.sku().equal("10000001"))
        .leftOuterJoin(c, { cols -> [c.Cost, c.Currency, c.SalesOrg, c.ValidFrom, c.ValidTo] },
                { cols ->
                    qapi.exprs().and(
                    c.sku().equal(cols.sku),
                    c.ValidFrom.lessOrEqual(today),
                    c.ValidTo.greaterOrEqual(today),
                    )
                })
        .stream { it.collect { it } }