Re: sql query?

From: chad baker <cmbaker3_at_bellsouth.net>
Date: Wed, 20 Feb 2002 19:21:11 -0600
Message-ID: <wPXc8.674$08.37036@e3500-atl1.usenetserver.com>

select tname from tourist where tid in (select tid from travel where city = 'Detroit' or city = 'Miami')

Chad

"D'laila Pereira" <dpereira_at_students.uiuc.edu> wrote in message news:Pine.GSO.4.31.0202201846420.15681-100000_at_ux5.cso.uiuc.edu...
>
> Given the following tables
> tourist(tid,tname)
> travel(tid,city, arrivaldate,stayindays)
>
> find, the names of the tourists who have visited "Detroit" and "Miami" but
> no other cities.
>
> Any hints on how to solve this one?
>
Received on Wed Feb 20 2002 - 19:21:11 CST