Answer
SELECT OwnerFirstName, OwnerLastName, OwnerEmail
FROM PET_OWNER
WHERE OwnerID IN (SELECT OwnerID FROM PET_3 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-19 - Pet Data - Page 214: 3.36
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.
