Explore BrainMass
Share

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
    https://brainmass.com/computer-science/files/writing-query-ms-access-129136

    Attachments

    Solution Preview

    SELECT Table_1.ORDER_NUMBER, Table_2.PP_NUMBER
    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.

    $2.19