Newbie SQL Question
From: Vinh Duong <vduong_at_aei.ca>
Date: Sun, 23 Jan 2000 23:05:03 -0500
Message-ID: <86gj1r$3nq$1_at_news.aei.ca>
[Quoted] I have three tables:
Date: Sun, 23 Jan 2000 23:05:03 -0500
Message-ID: <86gj1r$3nq$1_at_news.aei.ca>
[Quoted] I have three tables:
[Quoted] 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 Mon Jan 24 2000 - 05:05:03 CET