SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
CREATE TABLE T1 (A INTEGER PRIMARY KEY,B INTEGER); CREATE TABLE T2 (C INTEGER,D INTEGER); INSERT INTO T1 VALUES (2, 10); INSERT INTO T2 (C, D) VALUES (null, 1); INSERT INTO T2 (C, D) VALUES (1, 1); SELECT * FROM T1; SELECT * FROM T2; select distinct A from T1 right join T2 on T1.A=T2.C;
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear