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

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. •

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