Forum Discussion

mrbartolome's avatar
mrbartolome
Regular Visitor
4 years ago
Solved

undefined

  • 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's avatar
    Anonymous
    4 years ago

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

     

    --Nate

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

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

     

    --Nate