Join

1. Define Template->When we need to transform view’s data from two sql after merged in one row as per value of Primary KEY then we need to define primary and secondary sql for this key value should be same in both sql and other columns should be different in secondary.

Primary SQL-> we can define primary sql like this.

e.g: In this sql MainpartyID is KEY value.

Secondary SQL-> we can define secondary sql, in this sql value of primary key should be same and other columns should be different in secondary.

Note: {1} to be used for additional where conditions and {0} to be used for default.

2. Define Transform-> User can define join transformation like this.

MAINGRID -> we can define main grid using < MAINGRID >starting & < MAINGRID > ending tags.

e.g.:

JOIN -> User can merge two sql using INDEX1 and INDEX2 with defining JOINTYPE INNER/LEFT etc.

e.g.:

KEY -> User can set key field of Primary SQL to transform of view’s data.

JOINTYPE -> User can set type of joins using this key field like inner, left join etc.

SCROSS -> User can applied transform operation like SCROSS

e.g:

IDFIELD -> IDField and Value of KEY tag should be same.

Output: