data from two resident table

[#1]

I have created two resident table .

now i want data from those two table based on condition .

for eg

table1:

select

a,

b ,

c

from database

table 2

load

d,

e

from uvw.xlx

now i want to pull data from these two tables upon some condition

is thera ny way to do it .

for eg

a.[FieldA], a.[FieldB], b.[FieldD], sum(a.[FieldC]) as FieldX

resident Table1 a, resident Table2 b

where a.[FieldA] = b.[FieldA]

group by a.[FieldA], a.[FieldB], b.[FieldD]

order by a.[FieldA], a.[FieldB], b.[FieldD]

[Gysbert_Wassenaar]

A resident load accepts only one table as input.

where a.[FieldA] = b.[FieldA]

If both tables have a FieldA then you can join the two tables so you end up with one table. You can then use that table in a resident load to calculate the sum.

[er_mohit]

drop table2

sort by b.[FieldD]