Explore BrainMass

Explore BrainMass

    Query in Access

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    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


    Solution Preview

    FROM (Table_1 INNER JOIN Table_2 ON ...

    Solution Summary

    The solution writes a query in MS Access using tables 1-3 (see attachment). Concern to the problem are also mentioned.