Join ?

[#1]

Hi

I do not have any common key to join in both tables. I need to see STY_ID relevant BOO_PAYMENT_AMOUNT. For ex : STY_ID values are A,B,C….BOOKING PAYMENT AMOUNT values are 10,20,30 etc., If I click 'A' in STY_ID that should display the relevant value in BOO_PAYMENY_AMOUNT. How can do this if there's no common key in both tables ?

LOAD `BOO_CONFIRMED_DATE`,

`BOO_PAYMENT_AMOUNT`,

`OFF_CODE`;

SQL SELECT `BOO_CONFIRMED_DATE`,

`BOO_PAYMENT_AMOUNT`,

`OFF_CODE`

FROM A;

LOAD `PRD_ID`,

`STY_ID`;

SQL SELECT `PRD_ID`,

`STY_ID`

FROM B;

Your Suggestions will be highly appreciated.

Many Thanks

[Miguel_Angel_Baeyens]

Hello,

If value of both fields has a correspondence, then use it in a mapping table to link them with the same value:

CorrespondenceMap:MAPPING LOAD Chr(64 + RowNo()) AS STY_ID, // A, B, C... 10 * RowNo() AS BOO // 10, 20, 30...AUTOGENERATE 26; Table1:LOAD `BOO_CONFIRMED_DATE`,`BOO_PAYMENT_AMOUNT`,`OFF_CODE`;SQL SELECT `BOO_CONFIRMED_DATE`,`BOO_PAYMENT_AMOUNT`,`OFF_CODE`FROM A; Table2:LOAD `PRD_ID`,`STY_ID`,ApplyMap('CorrespondenceMap', `STY_ID`, 'No Correspondence') AS `BOO_PAYMENT_AMOUNT`;SQL SELECT `PRD_ID`,`STY_ID`FROM B;

Hope that helps.