Inner Join issues

[#1]

I am a new QV user and have the following question.

I have following 2 QVDs. I did inner join and stored it in the table.

The first QVD has for example 200 rows and 2nd has 100 rows. I need to get the common records from the 2 QVDs. I did the inner join as in the following. The result set get me 100 or less records. right? Am I doing this right?

SalesSubSet:

LOAD

DivDist,

DivItem,

Date,

Sum(ShipQty) as DistShipQty

FROM $(MBAQVDMaster)DF.qvd(qvd)

Group by DivDist, DivItem, Date;

Inner Join

LOAD

DivDist,

DivItem,

Date,

Sum(Qty) as MBAShippedQty

FROM $(MBAQVDMaster)MBAQ.qvd(qvd)

Group by DivDist, DivItem, Date;

STORE SalesSubSet INTO $(MBAQVDMaster)MacSubSet.qvd;

[Anonymous · Accepted solution]

Try this, note change on the Inner Join part.

SalesSubSet:

LOAD

DivDist,

DivItem,

Date,

Sum(ShipQty) as DistShipQty

FROM $(MBAQVDMaster)DF.qvd(qvd)

Group by DivDist, DivItem, Date;

Inner Join (SalesSubSet)

LOAD

DivDist,

DivItem,

Date,

Sum(Qty) as MBAShippedQty

FROM $(MBAQVDMaster)MBAQ.qvd(qvd)

Group by DivDist, DivItem, Date;

STORE SalesSubSet INTO $(MBAQVDMaster)MacSubSet.qvd;

[#3]

Thanks Rodrick. I will try this and will get back to you.