السلام عليكم
قاعدة البيانات مكونه من 3 جداول وقد اجتهت لتوضحيها
واما السؤال فهو فى اخر المشاركه
sp table sno mean supplier , pno mean parts s1 p1 300 mean supplier s1 supplie the company with part p1 and thw qty =300 sno pno Qty ---- ---- ----------- s1 p1 300 s1 p2 200 s1 p3 400 s1 p4 200 s1 p5 100 s1 p6 100 s2 p1 300 s2 p2 400 s3 p2 200 s4 p2 200 s4 p4 300 s4 p5 400 (12 row(s) affected) in this table p1 no of the supplier , pname mean the name pf the part ,color mean the color of the part city mean the place of the store which i take the parts from it pno pname color weight city ---- ---------- ---------- ----------- ---------- p1 nut red 12 london p2 bolt green 17 paris p3 screw blue 17 oslo p4 screw red 14 london p5 cam blue 12 paris p6 cog red 19 london (8 row(s) affected) sno mean supplier number sname mean suppliername, city the place who live sno sname status City ---- ---------- ----------- ---------- s1 smith 20 london s2 jones 10 paris s3 blake 30 paris s4 clark 20 london s5 dams 30 athens (5 row(s) affected) Question: write the query get supplier numbers for suppliers who supply at least all those parts supplied by supplier s2
اريد الاجابه بجمل الالاس كيو الا وليس ال ترانس اكت