How do I create a query that updates students credits to account for the books t

Question

How do I create a query that updates students credits to account for the books they've ordered and received from the following tables in Access. (Please put the query design as your answer and explain how to get pass the duplication of added credits.)

Books Book ID Book Title Number of Copies Credits 101 Problem Solving Cases in MS Access and Excel 10 3 102 Principles of Accounting I 120 5 103 General Chemistry 50 7 104 Physics Made Easy 15 2 105 Differential Equations 30 5 106 Engineering Analysis 120 4 107 Marketing Research 25 7 108 Operations Research 45 8 109 Financial Analysis 100 3 110 Effective Communication 200 2 Students ID Number of Credits B-17 24 F-59 30 L-29 10 M-62 25 P-91 18 Q-13 12 R-22 50 S-63 40 Z-30 27

Explanation / Answer

The update query is:

update Books set B.credits=S.credits from Books as B inner join Students as S inner join Orders as O on

S.StudentId=O.StudentId;

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.