DSXchange

Posted: **Fri Feb 29, 2008 10:00 pm**

Hi,

I am looking for a better way to do this task.

I have two tables (1 is main table which has details and other one table is summary) which has each 11 key columns as common.

I have join these two tables using these common columns and pull data pertaining to Detail table and Summary table.

Can it be done using hash file(hex) ???

Please help me.

Posted: **Fri Feb 29, 2008 11:04 pm**

Yes. Load the summary data into the Hashed file. Mark nall the 11 fields as Key. Do a lookup on the Hash file.And extract and join the rest of the fields.

Posted: **Sat Mar 01, 2008 8:31 am**

And you're sure this will be 'better'?

Posted: **Sat Mar 01, 2008 2:36 pm**

What do you mean by "(hex)" in the original question?

DSXchange

Join tables on multiple columns and pull matching data.

Join tables on multiple columns and pull matching data.