undefined

[mrbartolome]

• Hi  hope you can help.

I'm trying to get the total sum of quantity based on participating items (table 2) using data from table 1

please see tables below

TABLE 1

Item No     Qty

1                    5

2                    10

3                     2

4                      6

TABLE 2 (participating item list)

Item No

2

4

[Anonymous · Accepted solution]

on table two, I would use the merge-inner join function, using item no as the key columns.

--Nate