Using Exists between two resident Table's

[amars]

hi all,

I want to use Exists between two resident table. Actually I have two tables with same fields in it.

Table1, Table2 & I want to add the rows of Table2 to Table1 based on a single field value present in Table 1. I wish to use a statement like this Join (Table1) Load Field...... from Table2 Where exists(Field1, Load Field1 from Table1);

I really don't know how to do that. Could anyone tell me that. Thanks in advance

With Regards

Amar

[sparur]

Hello

CONCATENATE(Table1)

Load

Field1,

Field2

....

RESIDENT Table2

WHERE Exists(Field1, Field1);

where field "field1" exists on both tables.

but if you want join some fields from Table2 into Table1 you no need to use Exists function.

LEFT JOIN(Table1)

Load

Field1,

Field2

....

RESIDENT Table2;

after this field2 joined into Table1 by field "Field1"