1.) Get J# values for projects using at least one part available from supplier S
ID: 3740382 • Letter: 1
Question
1.) Get J# values for projects using at least one part available from supplier S1.1115 : Table E SPJ: Table St +S Smith +S2 Jones S3 Blake SA Clark S5 Adams 10 Paris SI PI IJA 700 30 ParisS2 P3 400 Status City 20 London S2 P3 22 30 Athens S2 P3 3 20 ? P : Table S2 P3 J5 600 S2 P3 J6 400 12 London $2 P3 7 800 P#LEName l Color! Weight! City SPJ PName Color P2 Bolt Green P3 Screw Blue 17 Paris 17 Rome 3 P3 S2 P5 J2100 200 50b Ba P4 M2 + P4-Screw-Red |. 14London +P6 Cog E J: Table P5 CamBlue Red 19 London SAP67 300 City J JName City 155 P5?JZ 1100 1 Sorter Paris +112 Punch Rome P6-14 J3 Reader AthensS 31200 +J4 Console Athens J5 Collator London J6 Terminal Oslo 3 S5 PI IJA | 1001 City S5 P5?JA 1400
Explanation / Answer
SELECT DISTINCT(J#) FROM SPJ WHERE S#='S1'
SELECT S.City, J.City FROM SPJ JOIN S ON SPJ.S#=S.S# JOIN J ON SPJ.J# = J.J#
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.