Question: Open the JoinQuery in SQL View. Add a WHERE clause that joins the Registration table and the Attendees table. The common field in both tables

Open the JoinQuery in SQL View. Add a WHERE clause that joins the Registration table and the Attendees table. The common field in both tables is AttendeelD. You will need to qualify the AttendecID ficld in the WHERE clause. Run the query and ensure that the results match that shown in Figure 17.(Hint: All rows are not displayed in the figure. The order of the records may differ. There should be 35 records in the result.) Save and close the Joinquery.
SELFCT RegistrationID, Attendeec.AttendeeiD, FirstName LastName FROM Registration, Attendees
 Open the JoinQuery in SQL View. Add a WHERE clause that

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!