Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, i want join two tables with the same fields but i have duplicated values. My tables are like this :
table1: table2:
article, desc, n°commande article, desc, joinedArticle, Grp
8855, fruit, 0205549 8855, fruit AB, 885596, rouleau
8855, fruit, 885595, rouleau
8855, fruit hg, 885585, rouleau
i also want to display values who don't match.
So my question is how to delete duplicated values and keep all my values ?
Hi,
Try:
DATA:
LOAD article,
desc,
n°commande
FROM
Table1
Left Join
LOAD DISTINCT article,
desc,
joinedArticle,
Grp
from
Table 2
Hi,
Try:
DATA:
LOAD article,
desc,
n°commande
FROM
Table1
Left Join
LOAD DISTINCT article,
desc,
joinedArticle,
Grp
from
Table 2