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

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

Update this answer!

You can help us out by revising, improving and updating this answer.

Update this answer

After 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.