I have two tables, I want to join two tables together, but I have an error key, please help me!!!
FR04_T07_FORMAT: LOAD LIFNR AS FR04_T07_LFA1_KEY, // BUKRS&BELNR&GJAHR AS FR04_T07_LFA1_KEY, BUKRS&BELNR&GJAHR AS FR04_T07_BSAK_KEY, LIFNR AS FR04_T07_LIFNR, BUKRS&BELNR&GJAHR AS FR04_T07_REGUP_KEY, SHKZG AS FR04_T07_SHKZG, XANET AS FR04_T07_XANET FROM [lib://ASAP_data (qlikserver-1_tamnguyen)/cjw@aufinia.com/QVD_DATA/Fi_Report/A_Fi_Report_BSAK.qvd] (qvd);
LEFT JOIN (FR04_T07_FORMAT) LOAD LFA1_NAME1_BSEG AS FR04_T07_LFA1_NAME1_BSEG, LFA1_KTOKK_BSEG AS FR04_T07_LFA1_KTOKK_BSEG, BSEG_LIFNR AS FR04_T07_LFA1_KEY FROM [lib://ASAP_data (qlikserver-1_tamnguyen)/AufiniaQ/QVD_DATA/B_PHASE/B_SS01_08_IT_BSEG_BKPF.qvd] (qvd);
