Purchase Solution

Query in Access

Not what you're looking for?

Ask Custom Question

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.

Attachments
Purchase this Solution
Solution Summary

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

Solution Preview

SELECT Table_1.ORDER_NUMBER, Table_2.PP_NUMBER
FROM (Table_1 INNER JOIN Table_2 ON ...

Purchase this Solution
Free BrainMass Quizzes
C++ Operators

This quiz tests a student's knowledge about C++ operators.

Excel Introductory Quiz

This quiz tests your knowledge of basics of MS-Excel.

Javscript Basics

Quiz on basics of javascript programming language.

C# variables and classes

This quiz contains questions about C# classes and variables.

Inserting and deleting in a linked list

This quiz tests your understanding of how to insert and delete elements in a linked list. Understanding of the use of linked lists, and the related performance aspects, is an important fundamental skill of computer science data structures.

View More Free Quizzes
Related BrainMass Solutions

  • Using a semicolon (;) in MS Access

    132585 Queries in Access I notice when writing queries that Access will add in a semicolon at the end of my query. Its just one of those Access things right? We don't have to remember to write the semicolon, as Access adds it in for us correct.

  • Query in Access 2000

    132319 Query in Access 2000 You can use the database "WEEK1_Q1_Q2_ACCESS2000.mdb" attached to Lecture 1 if you want to play around with this query before answering: OK, I'm writing a query in Access 2000: SELECT author_name

  • SQL pattern matching with MS Access

    The simple answer to your question, then, is that the first query doesn't return any results because it's an exact match query. This solution shows how to do pattern matching in a MS Access SQL query.

  • Access

    35750 Access Start Access, and then open the FirmPays database. Open the query named " June 2". View the query in SQL and answer the following questions. Explain your answers. Which tables are used in the query?

  • ACCESS 2000

    while you are in the query's design view, or if you have saved the query then you can double click on the query's name. When you close the query, Access will ask for a query name. Name your query "create_customers".

  • Creating Mail Merge using MS-Access

    Write a query that shows only the customers who live in MyTown 6. In that same query, concatenate the First Name and Last Name. Please call it FullName. 7. In that same query, concatenate the City, State and Zip code.

  • MS Access database

    76100 MS Access database (See attached file for full problem description) --- Implement the database in MS access with Relationships, tables, keys, indexes and a view(query) that duplicated the spreadsheet and list all functional dependencies and

  • Access Database

    285217 Microsoft Access Start Access, and then open the FirmPays database located in the LE4 folder extracted from the zip file in IP3. Open the query named "June 2".

  • This post addresses access database and queries.

    Have you ever read the SQL commands generated by a Query in Access database? Yes - the SQL commands are basically in-line with the table created in Access through a query.

View More Related Solutions