I have to join two tables and i don't know what join I have to use.
I need all registers of the first table and all registers of the second table that don't be in the first table. If there are repeated that are in both tables, I need only the register that is in the first table.
Attach my code:
PURCHS:
LOAD
TEXT(PURCHID) & '-' & TEXT(LINENUM) as PURCHLINE,
TEXT(INVENTDIMID) as INVENTDIMID,
TEXT(DIMENSION3_) as PROJECT,
NUM(PURCHPRICE) as PURCHPRICE,
TEXT(CURRENCYCODE) as CURRENCYCODE,
DATE(CONFIRMEDDLV) as CONFIRMEDDLV,
NUM(QTYORDERED) as QTYORDERED
FROM
[$(Ruta_QVD)\PURCHLINE.qvd] (qvd)
WHERE DATAAREAID = 'tase' ;
JOIN
LOAD
TEXT(PURCHID) & '-' & TEXT(LINENUM) as PURCHLINE,
TEXT(INVENTDIMID) as INVENTDIMID,
TEXT(DIMENSION3_) as PROJECT,
NUM(PURCHPRICE) as PURCHPRICE,
TEXT(CURRENCYCODE) as CURRENCYCODE,
DATE(CONFIRMEDDLV) as CONFIRMEDDLV,
NUM(QTYORDERED) as QTYORDERED
FROM
[$(Rute_QVD)\PURCHLINE_2003.qvd] (qvd)
WHERE DATAAREAID = 'aeo' ;
this code sometimes returns two registers with the same purchline, for example, it happens if the project or another attribute is different in both tables. I only would need the register of the first table. How can I do it?
concatenating both tables, for purchline='FB0B013722-3' returns two registers. The first, in which project is null, is in the second table and the second is in the first table. I would need the register that belongs to the first table that has filled the project field.
.png "sasikanth"){kind=avatar}
