Purchase Solution

SQL

Not what you're looking for?

Ask Custom Question

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". View the query in SQL, and answer the following questions:

Which tables are used in the query?
Which fields are displayed in the query results
What type of join is used between the tables
What selection criteria are used?
Then write a query in SQL in the FirmPays database that fulfills the following parameters:

Displays the AmtPaid, Firm#, DatePaid, and Payment#
Selects firm number 1115 and DatePaid between 6-1 and 6-10
Results should be ordered by payment date

Attachments
Purchase this Solution
Solution Summary

This posting contains answers to the given questions.

Solution Preview

Hi,

Please see attached for the modified database "FirmPays". under LE4 folder

The answer to the given questions are as follows:

Which tables are used in the query?
- The tables used in the query are the Payment and the Firm tables.

Which fields are displayed in the ...

Purchase this Solution
Free BrainMass Quizzes
Basic Networking Questions

This quiz consists of some basic networking questions.

C++ Operators

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

Javscript Basics

Quiz on basics of javascript programming language.

Word 2010: Tables

Have you never worked with Tables in Word 2010? Maybe it has been a while since you have used a Table in Word and you need to brush up on your skills. Several keywords and popular options are discussed as you go through this quiz.

Java loops

This quiz checks your knowledge of for and while loops in Java. For and while loops are essential building blocks for all Java programs. Having a solid understanding of these constructs is critical for success in programming Java.

View More Free Quizzes
Related BrainMass Solutions

  • Information Systems- SQL Servers

    The SQL Server 2008 was able to meet those demands by offering the SQL Server 2008 over SQL Server 2005.

  • SQL

    94707 SQL and Relational Databases Why is SQL such an important query language for relational databases?

  • Maintenance Tools in MS SQL 2005

    SQL Management Objects (SMO): SQL Management Objects (SMO) is a new set of programming objects that expose the functionality of the SQL Server database.

  • SQL Query: Student Information

    510726 SQL Query: Student Information Query1 Write a SQL statement to display Students' First and Last Name. Query2 Write a SQL statement to display the Major of students with no duplications. Do not display student names.

  • This posting addresses primary keys using SQL.

    References: Beginner SQL Tutorial. (2011). SQL Integrity Constraints. Learn SQL Programming. Retrieved from http://beginner-sql-tutorial.com/sql-integrity-constraints.htm W3Schools.com. (2012). SQL Primary Key Constraint. SQL Advanced.

  • Writing SQL Queries Using a Database and Tables

    In Microsoft SQL Server Management Studio, save your SQL statements as .SQL files. Save your SQL output as .RPT files. You will need to post both types of files (.SQL and .RPT). Please see attached SQL, RPT files.

  • Migration from Access

    Include a discussion on SQL: What is SQL? Who owns SQL? What are some of the differences in the SQL supported by RDBMS vendors?

  • Oracle9i

    After log in to SQL*Plus SQL> ALTER USER CLASSMATE IDENTIFIED BY STUDENT SQL>EXIST And try log using User ID:CLASSMATE and Password: STUDENT b.

  • PL/SQL package

    Entering New Movie Form: Invoking SQL*Forms : SQL*Plus and SQL*Menu are both linked together when SQL*Menu is installed.

  • Develop database tables using a relational database system

    Include a discussion on SQL: What is SQL? Who owns SQL? What are some of the differences in the SQL supported by RDBMS vendors?

View More Related Solutions