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

Home -> Community -> Usenet -> c.d.o.server -> Newbie SQL Question

Newbie SQL Question

From: Vinh Duong <vduong_at_aei.ca>
Date: Sun, 23 Jan 2000 23:03:55 -0500
Message-ID: <86givq$3nl$1@news.aei.ca> 





I have three tables:



Mechanic(mid, mname, job_title, city) mid is the primary key
Works_in(mid, gid, hours_per_week) where mid & gid are the primary keys
Garage(gid, manager, city) where gid is the primary key



How to write the SQL queries to:


- List the mechanics who work in more than one garage in different cities.



When reply, please copy me at vduong_at_aei.ca



Gracias,



Vinh


Received on Sun Jan 23 2000 - 22:03:55 CST












Original text of this message













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