Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Cost Accounting

Authors: Les Heitger, Pekin Ogan, Serge Matulich

2nd Edition

053881764X, 978-0538817646

More Books

Students also viewed these Accounting questions

Question

What is memory?

Answered: 1 week ago

Question

Why would unions target health care workers?

Answered: 1 week ago