Data Modeling and Design_Unit4_IP

Data Modeling and Design_Unit4_IP - What type of join is...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Data Modeling and Design Unit 4 Individual Project Kregg M. Soltow April 14, 2011 American Intercontinental University 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 query results The fields shown in the query are the Payment#, AmtPaid and FirmName fields.
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: What type of join is used between the tables The type of join used between the tables is INNER JOIN What selection criteria is used? An example of the selection criteria used is; if the Payment.DatePaid column contains the date 6/5/2001. The clause that specifies the selection criteria is WHERE (((Payment.DatePaid)=#6/5/2001#));...
View Full Document

Ask a homework question - tutors are online