Oracle Development
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me
Go Back   Dev Shed ForumsDatabasesOracle Development

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Dev Shed Forums Sponsor:
Stay one step ahead of the competition. Evaluate and give feedback on some of the hottest web development tools on the market today. Make your opinion heard! Click Here
  #1  
Old May 21st, 2004, 03:17 AM
ausmedia ausmedia is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: May 2004
Posts: 12 ausmedia User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 1 h 43 m 45 sec
Reputation Power: 0
Need help with 3 tables. Help Plz

Supplier table
Table Name: S

S# SNAME STATUS CITY
--- ------------ ---------- ------------
s1 Smith 20 London
s2 Jones 10 Paris
s3 Blake 30 Paris
s4 Clark 20 London
s5 Adams 30 Athens

Parts table
Table Name: P

P# PNAME COLOR WEIGHT CITY
--- ------------ ------ ---------- ------------
p1 Nut Red 12 London
p2 Bolt Green 17 Paris
p3 Screw Blue 17 Rome
p4 Screw Red 14 London
p5 Cam Blue 12 Paris
p6 Cog Red 19 London

Project table
Table Name: J

J# JNAME CITY
--- ------------ ------------
j1 Sorter Paris
j2 Punch Rome
j3 Reader Athens
j4 Console Athens
j5 Collator London
j6 Terminal Oslo
j7 Tape London

Shipment table
Table Name: SPJ

S# P# J# QTY
--- --- --- ----------
s1 p1 j1 200
s1 p1 j4 700
s2 p3 j1 400
s2 p3 j2 200
s2 p3 j3 200
s2 p3 j4 500
s2 p3 j5 600
s2 p3 j6 400
s2 p3 j7 800
s2 p5 j2 100
s3 p3 j1 200
s3 p4 j2 500
s4 p6 j3 300
s4 p6 j7 300
s5 p2 j2 200
s5 p2 j4 100
s5 p5 j5 500
s5 p5 j7 100
s5 p6 j2 200
s5 p1 j4 100
s5 p3 j4 200
s5 p4 j4 800
s5 p5 j4 400
s5 p6 j4 500

Those are my 3 tables.

The question is:

Get P#'s for parts supplied by more than one supplier or to more than one project.

could someone please help me create a query for the question above???

Reply With Quote
  #2  
Old May 21st, 2004, 09:35 AM
shafique shafique is offline
Senior Member
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Sep 2003
Location: Canada
Posts: 305 shafique User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 2 h 45 m 20 sec
Reputation Power: 5
little bit difficult, see the attachement.
Attached Files
File Type: txt query5.txt (383 Bytes, 171 views)

Reply With Quote
Reply

Viewing: Dev Shed ForumsDatabasesOracle Development > Need help with 3 tables. Help Plz


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 4 hosted by Hostway