Friday, December 31, 2010

Query “join table A with table B and table A with table C”

//
Query query = new Query();
QueryBuildDataSource qbds,qbds1,qbds2;
qbds = query.addDataSource(tableNum(CustTable));
qbds1 = qbds.addDataSource(tableNum(CustTrans));
qbds2 = qbds1.addDataSource(tableNum(CustLedgerTransTypeMapping));
qbds1.addLink(fieldNum(CustTrans,AccountNum),fieldNum(CustTable,AccountNum));
qbds2.addLink(fieldNum(CustTrans,TransType),fieldNum(CustLedgerTransTypeMapping,CustSettleTransType));
info(query.toString());

1 comment:

  1. Thanks for the Great Post!!!
    Prancer is a pre-deployment and post-deployment multi-cloud platform for Infrastructure as Code pipeline and continuous compliance in cloud

    ReplyDelete

Leave your comments and solutins