Join Example

Join Example

    ....

    //Inner join tuples
    List<JoinField> jf;
    jf = new ArrayList();

    // rs1.field1 = rs2.field1
    jf.add(new JoinField("rs1 field1 name", "rs2 field1 name"));

    // rs1.field2 = rs2.field2
    jf.add(new JoinField("rs2 field2 name", "rs2 field2 name"));

    //Join data into a new rowset
    rs1.beforeFirst();
    CompressedRowSet rsJoin = rs1.join(rs2, jf);

    ...