Join tables on QV

[#1]

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 ?

[hcabrera · Accepted solution]

Hi,

Try:

DATA:

LOAD article,

          desc,

          n°commande

FROM

Table1

Left Join

LOAD DISTINCT article,

          desc,

          joinedArticle,

         Grp

from

Table 2