Computer Science Homework Solutions
Problem
#129136

Query in MS Access

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 shoud write in such as (sql) SELECT what columns FROM WHAT tables WHERE somthing or INNER JOIN. The query should run to get the result. When you finish. please attached the mdb file, so I can see how you write the codes.

See attached file for full problem description.

Attached file(s):
Attachments
TABLE_1.xls  View File
Solution
What is this?
By OTA - Overall OTA Rating
Yanfang Li, PhD - 4.9/5
Purchase Cost Now
$2.19 CAD (was ~$19.95)
Included in Download
  • Plain text response
  • Attached file(s):
    • db1.mdb
$2.19 Instant Download
Add to Cart
Why you can trust BrainMass.com
  • Your Information is Secure
  • Best Online Academic Help Service
  • Students find real academic Success
Related Solutions
  • QUERY in MS ACCESS - Please see attached file for three tables in excel format. I need to query three tables by using LAST_NAME and FIRST_NAME in table_1 to find matching ORDER_NUMBER and PP_NUMBER in table_2 and table_3 ...
  • Oracle9i Database - 1. How can this be corrected? 2. Fix the view.
  • Name Header - Here is what the NAME HEADER file (Name.h) will have: 1. a default constructor 2. 3 private string instance variables for : FIRST NAME, MIDDLE NAME, and LAST NAME 3. getFirstLast Function: it ...
  • Microsoft SQL STATEMENTS - I am using Microsoft SQL Server 2000 1. Database Tables TABLE: Employees Job_title_code Social_security_number Last_name First_name Address City Sta ...
  • Question 2 - If you have TABLE A with these columns (I put the data type in parenthesis, they are not actually part of the table name): LAST_NAME(TEXT), FIRST_NAME(TEXT), MIDDLE_NAME(TEXT), DATE_O ...
Browse