I want someone help me to do my homework IFMG 101 In myITlab
abdon_
exploring_a01_grader_h1.accdb| Author ID | LastName | FirstName | mSysRowId |
|---|---|---|---|
| 11 | Beschloss | Michael R. | zPQ5hQZq2467KXYUuBkTcxDbZyDuLpv0yKm1+5hEM44=-~RJoSksjCKmGp4+BrIBYjUw== |
| 12 | Mulbery | Keith | tZxxFJQar71XbXexgLmIPN6LKJzuHFn9aUvczToq6vY=-~99FxbndbIrGKlCHl79HCfA== |
| 13 | Rice | Anne | P1vbsKdPC2o6zAAk8foEPaqCCv65Qiq793X+hMFejp0=-~RNFY/40WxQ4ESzDg4JprIA== |
| 14 | King | Steven | mXuWL2Ksmh8Q5N/teZbg5imwMA6NC/5nZX554UR3uPo=-~g4PXYUAO+vOhE5/53xGbsw== |
| 15 | Harvey | Michael | Pfmwcq3UnsNojfO4dccMaDQvccRJFWxhlXXTPJ3fl8Q=-~IW2AVdI1OvsswQ733Pg6kQ== |
| 16 | Rice | Luanne | c2QNCnpcVb6M+SCLXm/pFErTVnxLm14Viln6wyBjpXM=-~c+Tdbwo3/8Iu/HTCKq8OnA== |
| AuthorCode | Title | ISBN | PubID | PublDate | Price | StockAmt |
|---|---|---|---|---|---|---|
| 13 | The Wolf Gift | 0-307-59511-0 | KN | 2012.0 | 14.5 | 42.0 |
| 13 | Blackhills Farm | 0-275-41199-7 | KN | 2011.0 | 18.87 | 28.0 |
| 14 | Cell: A Novel | 0-340-92144-7 | SS | 2006.0 | 18.9 | 195.0 |
| 13 | Interview with the Vampire | 0-394-49821-6 | KN | 2006.0 | 19.57 | 371.0 |
| 16 | True Blue | 0-553-38398-0 | BB | 1981.0 | 7.5 | 492.0 |
| 16 | Dream Country | 0-553-38581-X | BB | 2008.0 | 10.42 | 76.0 |
| 16 | Follow the Stars Home | 0-553-58102-3 | BB | 2007.0 | 6.99 | 496.0 |
| 13 | Blood and Gold | 0-679-45449-7 | KN | 2005.0 | 18.87 | 640.0 |
| 11 | Reaching for Glory | 0-684-80408-5 | SS | 2006.0 | 24.0 | 480.0 |
| 12 | Computer Wisdom | 0-684-80415-5 | PH | 2006.0 | 23.5 | 75.0 |
| 12 | Computer Wisdom II | 0-684-80416-5 | PH | 2011.0 | 28.0 | 27.0 |
| 14 | Hearts in Atlantis | 0-684-85351-5 | SS | 2000.0 | 13.5 | 528.0 |
| 11 | Presidential Courage | 0-684-85705-7 | SS | 2007.0 | 24.0 | 120.0 |
| 14 | From a Buick 8 | 0-743-21137-5 | SS | 2004.0 | 16.8 | 368.0 |
| 14 | 11/22/63 | 1-451-62728-9 | SS | 2012.0 | 18.9 | 430.0 |
| ID | mSysRowId |
|---|---|
| 1 | CKARPgepJm7l9zWCNUMWoznoiX9mzFj1nwcENjN5iTI=-~caVnBBPw0w3Z1QM32GQ+SA== |
PARAMETERS __Author ID Value;
SELECT DISTINCTROW *
FROM Books AS [Maintain Authors]
WHERE ([__Author ID] = AuthorCode);
SELECT DISTINCTROW *
FROM Author;
SELECT Books.Title, Author.LastName, Author.FirstName, Publishers.PubName
FROM Publishers INNER JOIN (Author INNER JOIN Books ON Author.[Author ID] = Books.AuthorCode) ON Publishers.PubID = Books.PubID;
