I'm trying to combine 2 different qvd's into one table. Here is what I have.
INVOICE:
LOAD
hdr_key,
entity as [entity code],
[cash discount amt] as [amount],
[cash discount gl account] as [gl account]
FROM $(vPathNameLayer1)inc-hdr-all.qvd(qvd);
JOIN
LOAD
hdr_key,
line_key,
[line gpsa] as [amount],
[line item gl account] as [gl account]
FROM $(vPathNameLayer1)inc-line-all.qvd(qvd);
When I do this then entity code is not showing up for anything from the second join. How do I accomplish this? Here is what I would do in SQL but it doesn't like the syntax.
JOIN
LOAD
hdr_key,
entity as [entity code],
line_key,
[line gpsa] as [amount],
[line item gl account] as [gl account]
FROM $(vPathNameLayer1)inc-line-all.qvd(qvd) as a,
$(vPathNameLayer1)inc-hdr-all.qvd(qvd) as b
WHERE a.hdr_key = b.hdr_key;
