Hi - I would like to know how to match data from 2 different tables and then join them.
For Example -
Table #1
Part (With version) | Quantity
ABB-V1 | 2
ABB - V2 | 3
CC-V1 | 1
Table #2 - Product Data Table
Base Part (W/o version) | MSRP
ABB | $184.00
CC | $120.00
Desired Outcome
Base Part | Quantity | MSRP
ABB | 5 | $184.00
CC | 1 | $120.00