Group by function

[#1]

Have a requirement to sum up total sale amount for each region from two different text files. In one file i have geography information and in another file have sales information at sub-region wise. Have to join with first file to get region level total sales information.

example: select total_sales, region from sales, geography where sales.sub_region=geography.sub_region group by geography.region.

Please provide your ideas.

[#2]

hi

try according to this example

firstly join two table in one table.

NewTable:

table1

join

table2

**************************

then

output:

load

field1,

sum(field2)

resident NewTable

group by field1;