|dbxquery connection="DB1"
query="SELECT COLUMN1,COLUMN2 FROM TABLE1 where COULMN1 in(123, 124, 234, 235)"
shortnames=1 maxrows=10000|table *|rename COLUMN1 as MAINFIELD
|join type=left MAINFIELD[|dbxquery connection="DB2"
query="SELECT distinct COLUMN3,COLUMN4,COLUMN5 FROM TABLE2"
shortnames=1 maxrows=100]|table COLUMN1,COLUMN2,COLUMN3,COLUMN4
EXPLANATION: COLUMN1 is primary_key in TABLE1 and datatype is number. COLUMN3 contains the same value as COLUMN1 but datatype is "varchar". COLUMN3 has same value as COLUMN1 ALWAYS or it will be null. so i want to do left join. so that if value is not null then it will populate value of COLUMN4 also in final table.
Now i want to join COLUMN4 IN TABLE1 if value of COLUMN1 is equals to value of COLUMN2 field.
my final table looks like
COLUMN1 COLUMN2 COLUMN4
... View more