i want a Query that show all of S# and Sname that they have all red P# : i have a database :

S(S#,Sname,status,City)

P(P#,Pname,color,weight,city)

SP(S#,P#,number)

i want a Query that show all of S# and Sname that they have all red P#.

example:

S:

S1 Sname1 status1 city(1)

S2 Sname2 status2 City(2)

S3 Sname3 status3 City(3)


P:

P1 Pname1 red weight1 city(n)

P2 Pname2 blue weight2 city(n)

P3 Pname3 green weight3 city(n)

P4 Pname4 red weight4 city(n)


SP:

S1 P1 number1

S1 p4 number2

s2 p1 number3

s3 p3 number4

S3 p1 number5

S3 p4 number6

S2 p2 number7


Expected answer:

S1,Sname1

S3,Sname3

