Please see attached file and using LAST_NAME and FIRST NAME in Table_1 to find the matching order_number and pp_number in Table_2 and Table_3. The query should write in such as (sql) SELECT what columns FROM WHAT tables WHERE something or INNER JOIN. The query should run to get the result. When you finish please attach the mdb file to see how you wrote the codes.
See attached file for full problem description.© BrainMass Inc. brainmass.com October 9, 2019, 7:47 pm ad1c9bdddf
SELECT Table_1.ORDER_NUMBER, Table_2.PP_NUMBER
FROM (Table_1 INNER JOIN Table_2 ON ...
The solution writes a query in MS Access using tables 1-3 (see attachment). Concern to the problem are also mentioned.