SQLize Online / PHPize Online  /  SQLtest Online

CREATE TABLE R(X INT, Y1 INT, Z1 INT, Y2 INT, Z2 INT, Y3 INT, Z3 INT); CREATE TABLE S(Y1 INT, Z1 INT); CREATE TABLE T(Y2 INT, Z2 INT); CREATE TABLE P(Y3 INT, Z3 INT); INSERT INTO R(X,Y1,Z1,Y2,Z2,Y3,Z3) VALUES (1,1,1,10,1,10,1), (2,1,2,1,2,20,2), (3,30,3,1,3,1,3), (4,40,4,40,4,1,4); INSERT INTO S(Y1,Z1) VALUES (1,1), (1,2), (30,3), (40,4); INSERT INTO T(Y2,Z2) VALUES (1,2), (1,3), (10,1), (40,4); INSERT INTO P(Y3,Z3) VALUES (1,3), (1,4), (10,1), (20,2); CREATE VIEW S2(Y1,Z1) AS SELECT * FROM S; CREATE VIEW T2(Y2,Z2) AS SELECT * FROM T; CREATE VIEW P2(Y3,Z3) AS SELECT * FROM P; SELECT * FROM R JOIN S ON S.Y1 = R.Y1 AND S.Z1 = R.Z1 JOIN T ON T.Y2 = R.Y2 AND T.Z2 = R.Z2 JOIN P ON P.Y3 = R.Y3 AND P.Z3 = R.Z3; CREATE VIEW Results(X,Y1,Z1,Y2,Z2,Y3,Z3) AS SELECT * FROM R JOIN S ON S.Y1 = R.Y1 AND S.Z1 = R.Z1 JOIN T ON T.Y2 = R.Y2 AND T.Z2 = R.Z2 JOIN P ON P.Y3 = R.Y3 AND P.Z3 = R.Z3; CREATE VIEW S_Conflicts(X,Y1) AS SELECT X, Y1 FROM Results WHERE NOT EXISTS(SELECT * FROM Results as bad WHERE bad.X = Results.X and bad.Y1 = Results.Y1); SELECT * FROM Results; SELECT * FROM S_Conflicts;