SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
create table T1 (tt INT); insert into T1 value (1); insert into T1 value (2); insert into T1 value (3); insert into T1 value (4); insert into T1 value (5); create table T3 SELECT T1.tt+5 as tt FROM T1; create table T2 SELECT * FROM T1 UNION SELECT * from T3; select T3.tt as 'num3', T2.tt as 'num2',T1.tt as 'num1' from T2 full JOIN (T1 JOIN T3) on IFNULL(T1.tt,0)+ IFNULL(T2.tt,0)+ IFNULL(T3.tt,0)=10;
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear