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 Hint: All rows are not displayed in the figure. The order of the records may differ. There should be records in the result. Save and close the Joinquery.
SELFCT RegistrationID, Attendeec.AttendeeiD, FirstName LastName FROM Registration, Attendees
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
