double residents?? if you get what i mean

[#1]

eg..

Table1:

Load

Feild1

from souce;

table2:

Load

Feild2

from source;

doubleRes:

load feild1, feild2 resident table1, table2;

is this possible?

i know a join will do it but the situation is more complex than you could imagine.

thanks in advance

rhys

[#2]

don't owrry i found a way

just res loaded both then joined >__>

[its_anandrjs]

Hi,

You can use joins for two tables or otherwise concatenate the two tables is good idea i think.

Thanks,