Answer
SELECT OwnerFirstName, OwnerLastName, OwnerEmail
FROM PET_OWNER JOIN PET ON
PET_OWNER.OwnerID = PET.OwnerID
WHERE PetType = 'Cat'
AND PetName = 'Teddy'
Work Step by Step
N/A
Database Concepts
by Kroenke, David; Auer, David;
Published by
Pearson
ISBN 10:
0133544621
ISBN 13:
978-0-13354-462-6
Chapter 3 - Structured Query Language - Figure 3-20 - Pet_3 Data - Page 215: 3.39
Update this answer!
You can help us out by revising, improving and updating this answer.
Update this answerAfter you claim an answer you’ll have 24 hours to send in a draft. An editor will review the submission and either publish your submission or provide feedback.
