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_at_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 Thu Feb 21 2002 - 02:21:11 CET

This message: [ Message body ]
Next message: Morten: "Re: sql query?"
In reply to D'laila Pereira: "sql query?"
Next in thread: Morten: "Re: sql query?"
Reply: Kieran Elby: "Re: sql query?"
Reply: Jeff Zucker: "Re: sql query?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message