Linking Tables

Mon, 17 Dec 2012 06:12:28 GMT

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

Re: Linking Tables

Mon, 17 Dec 2012 06:34:15 GMT

Please any idea on this?

sujeetsingh — Mon, 17 Dec 2012 06:49:59 GMT

Just go with joins or concatenatio...whatever suits your requirement...

Just join them in another table and drop the both