Hi,
I would like to ask for help. I have 3 tables that needs to be linked to each other.
Table 1
Load
DATE
LINEPRICE as LINEAMOUNT,
ENTRYID & '-' & DATE &'-'& BRANCHNAME as GNDLINEKEY,
ITEM &'-'& TXNNUMBER &'-'& BRANCHNAME as COMBOKEY
Resident PARENT_TEMP
where VOIDED <> 1;
Table 2
LOAD
COMBOITEM &'-'& TXNNUMBER &'-'& BRANCHNAME as COMBOKEY
Resident GNDITEM_COMBO_TEMP
where VOIDED <> 1;
Table 3
LOAD
ENTRYID & '-' & date(floor(TRIM(DOB))) &'-'& TextBetween(FileBaseName(),'_','_') as GNDLINEKEY
FROM
$(DIR1)KR_*_GNDLINE_2012.qvd
(qvd)
I need to link table 2 and 3 without creating loops.
Thanks in advance,
Janzen
