SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
CREATE TABLE R(X INT, Y INT); CREATE TABLE S(Y INT, X INT); INSERT INTO R(X,Y) VALUES (1,1),(2,1),(3,2),(4,2),(5,3); INSERT INTO S(Y,X) VALUES (1,1),(1,2),(2,3),(2,4),(3,5); SELECT * FROM R; SELECT * FROM S; CREATE VIEW ANSWERS(X) AS SELECT R.X FROM R JOIN S ON S.Y=R.Y AND S.X=R.X; CREATE VIEW SIMPLE(X1,X2) AS SELECT R1.X AS X1, R2.X AS X2 FROM ANSWERS AS R1 JOIN ANSWERS AS R2 ON (R1.X!=R2.X) AND (R1.X=R2.X OR R1.Y!=R2.Y) AND (R1.Y=R2.Y OR R1.X!=R2.X); SELECT * FROM ANSWERS; SELECT * FROM SIMPLE;
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear