Find the guide last name and guide first name of all guides who can lead a paddling
Fantastic news! We've Found the answer you've been seeking!
Question:
Find the guide last name and guide first name of all guides who can lead a paddling trip. (Note: The query results should include duplicate values.
select guide.last_name,guide.first_name
from guide,trip
where guide.state=trip.state and type='Paddling'
order by last_name,first_name;
but still had duplicates need to remove the duplicates
Related Book For
Concepts of Database Management
ISBN: 978-1285427102
8th edition
Authors: Philip J. Pratt, Mary Z. Last
Posted Date: