Purchase Solution

Address Payments in a Database - SQL Query

Not what you're looking for?

Ask Custom Question

Start Access, and then open the FirmPays database located in the le4 folder of the zip file. Open the query named "June 2". View the query in SQL, and answer the following questions:

1. Which tables are used in the query?
2. Which fields are displayed in the query results
3. What type of join is used between the tables
4. 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

Deliverables: answers to questions 1-4, your SQL statement.

Attachments
Purchase this Solution

Solution Summary

This posting contains answers to a few questions based on the given SQL query. The SQL query is also created and attached to the solution.

Purchase this Solution


Free BrainMass Quizzes
Basic Computer Terms

We use many basic terms like bit, pixel in our usual conversations about computers. Are we aware of what these mean? This little quiz is an attempt towards discovering that.

Javscript Basics

Quiz on basics of javascript programming language.

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.

Basic Networking Questions

This quiz consists of some basic networking questions.

C++ Operators

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