SQLize Online / PHPize Online  /  SQLtest Online

CREATE TABLE R ( X INT, K INT, Y INT ); CREATE TABLE S1 ( Y INT, X INT ); CREATE TABLE S2 ( Y INT, X INT ); INSERT INTO R (X, K, Y) VALUES (1, 1, 1),(2, 1, 1),(3,1,3); INSERT INTO S1(Y, X) VALUES (1, 1),(1,2),(3,3); INSERT INTO S2(Y, X) VALUES (1, 1),(1,2),(3,3); SELECT * FROM R; SELECT * FROM S1; SELECT * FROM S2; CREATE VIEW T(X,Y,K) AS SELECT R.X,R.Y, R.K FROM R JOIN S1 ON S1.Y = R.Y AND S1.X=R.X JOIN S2 ON S2.Y = R.Y AND S2.X=R.X; CREATE VIEW OPP(X1,X2) AS SELECT T1.X, T2.X FROM T AS T1 JOIN T AS T2 ON T1.X != T2.X AND ( (T1.X = T2.X AND (T1.K != T2.K OR T1.Y != T2.Y)) OR (T1.Y = T2.Y AND T1.X != T2.X) OR (T1.Y = T2.Y AND T1.X != T2.X)); SELECT * FROM T; SELECT * FROM OPP; CREATE VIEW OK(X) AS SELECT X FROM T WHERE NOT EXISTS(SELECT * FROM OPP WHERE X1=X OR X2=X); SELECT * FROM OK;