Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> sql query?

sql query?

From: D'laila Pereira <dpereira_at_students.uiuc.edu>
Date: Wed, 20 Feb 2002 18:46:59 -0600
Message-ID: <Pine.GSO.4.31.0202201846420.15681-100000@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 - 18:46:59 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US