join and Concatenate

[#1]

I have four tables a,b,c,d

how can I get the result

(a join b)

Concatenate

(c join d),

a:

load * from a.qvd;

join (a)

load * from b.qvd;

Concatenate (a)

load * from c.qvd;

join

load * from d.qvd;

seems wrong

Best Regards !

[nagaiank]

Maybe the following will work:

ab:

load * from a.qvd (qvd)

join (ab) load * from b.qvd (qvd);

cd:

noconcatenate load * from c.qvd (qvd);

join (cd) load * from d.qvd (qvd);

join (ab) load * resident cd;

drop table cd;

[#3]

Thanks for your answer.

[jonathandienst]

You may want to concatenate for the last step. This is very different to a join in the last step if the field names are the same in (a join b) and (c join d). The code is mostly the same:

ab:

load * from a.qvd (qvd)

join (ab) load * from b.qvd (qvd);

cd:

noconcatenate load * from c.qvd (qvd);

join (cd) load * from d.qvd (qvd);

concatenate(ab)

load * resident cd;

drop table cd;

Hope that helps

Jonathan