common fields

[#1]

Hello,

I need to create a table  which contains the common fields of two other tables.

How can I do that?

[sushil353]

use:

Qualifier key word:

tab1:

load

from X

qualify *;

tab2

load

from y

HTH

Sushil

[#3]

Hi,

a really short question. Do you have an example explaining your intension?

Best Sacho

[gaurav2017]

Hi,

Hope this is what u desire:

Temp1:

Load a,

        b,

        c

from temp1.qvd;

Join (Temp2)

Load b,

        c,

        d

from temp2.qvd;

Temp:

load b, c resisdent Temp1;

Drop table Temp1;

I am just wildly guessing the solution as i can't understand your requirements.

regards,