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 COALESCE(T1.tt,0), COALESCE(T2.tt,0), COALESCE(T3.tt,0) from T2 left JOIN (T1 JOIN T3) on COALESCE(T1.tt,0)+ COALESCE(T2.tt,0)+ COALESCE(T3.tt,0) =10 where COALESCE(T1.tt,0)+ COALESCE(T2.tt,0)+ COALESCE(T3.tt,0) =10; select ifnull(T1.tt,0), ifnull(T2.tt,0), ifnull(T3.tt,0) from T2 left JOIN T1 on ifnull(T2.tt,0)+ifnull(T1.tt,0)=10 left join T3 on ifnull(T2.tt,0)+ifnull(T3.tt,0)=10 where COALESCE(T1.tt,0)+ COALESCE(T2.tt,0)+ COALESCE(T3.tt,0) =10; select ifnull(T1.tt,0), ifnull(T2.tt,0), ifnull(T3.tt,0) from T1 left JOIN T2 on ifnull(T2.tt,0)+ifnull(T1.tt,0)=10 left join T3 on ifnull(T2.tt,0)+ifnull(T3.tt,0)=10 where COALESCE(T1.tt,0)+ COALESCE(T2.tt,0)+ COALESCE(T3.tt,0) =10; select ifnull(T1.tt,0), ifnull(T2.tt,0), ifnull(T3.tt,0) from T3 left JOIN T1 on ifnull(T3.tt,0)+ifnull(T1.tt,0)=10 left join T2 on ifnull(T2.tt,0)+ifnull(T3.tt,0)=10 where COALESCE(T1.tt,0)+ COALESCE(T2.tt,0)+ COALESCE(T3.tt,0) =10; select COALESCE(T1.tt,0), COALESCE(T2.tt,0), COALESCE(T3.tt,0) from T2 left JOIN (T1 JOIN T3) on COALESCE(T1.tt,0)+ COALESCE(T2.tt,0)+ COALESCE(T3.tt,0) =10 where COALESCE(T1.tt,0)+ COALESCE(T2.tt,0)+ COALESCE(T3.tt,0) =10 union select ifnull(T1.tt,0), ifnull(T2.tt,0), ifnull(T3.tt,0) from T2 left JOIN T1 on ifnull(T2.tt,0)+ifnull(T1.tt,0)=10 left join T3 on ifnull(T2.tt,0)+ifnull(T3.tt,0)=10 where COALESCE(T1.tt,0)+ COALESCE(T2.tt,0)+ COALESCE(T3.tt,0) =10 union select ifnull(T1.tt,0), ifnull(T2.tt,0), ifnull(T3.tt,0) from T1 left JOIN T2 on ifnull(T2.tt,0)+ifnull(T1.tt,0)=10 left join T3 on ifnull(T2.tt,0)+ifnull(T3.tt,0)=10 where COALESCE(T1.tt,0)+ COALESCE(T2.tt,0)+ COALESCE(T3.tt,0) =10 union select ifnull(T1.tt,0), ifnull(T2.tt,0), ifnull(T3.tt,0) from T3 left JOIN T1 on ifnull(T3.tt,0)+ifnull(T1.tt,0)=10 left join T2 on ifnull(T2.tt,0)+ifnull(T3.tt,0)=10 where COALESCE(T1.tt,0)+ COALESCE(T2.tt,0)+ COALESCE(T3.tt,0) =10 order by 1,2,3
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear