Three qvds joined by a 1 LEFT join 2 and a 1&2 UNION ALL 3

[matthewp]

I have 3 source qvds that i want to load.

one.qvd

two.qvd

three.qvd

Currently i load..

one.qvd

LEFT JOIN (one)

two.qvd

like this:

ONE:

LOAD

fielda,

fieldb,

... etc

FROM

one.qvd (qvd);

LEFT JOIN(ONE)

TWO:

LOAD

fielda,

fieldb,

... etc

FROM

two.qvd (qvd);

resulttable

NoConcatenate

LOAD *

Resident ONE

DROP TABLE ONE;

And this works perfectly.

What i want to do is bring in three.qvd but add it to the bottom (like a UNION ALL) so it would load like this..

one.qvd

LEFT JOIN (one)

two.qvd

UNION ALL

three.qvd

How can i do this?

[sunny_talwar]

Try concatenate here:

resulttable:

NoConcatenate

LOAD *

Resident ONE

DROP TABLE ONE;

Concatenate (resulttable)

LOAD *

FROM

three.qvd (qvd);

[sushil353]

Try :

One:

load *

one.qvd

LEFT JOIN (One)

two.qvd

concatenate(One)

three.qvd