SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
CREATE TABLE matches ( id int, P1_01 int, date date ); INSERT INTO matches VALUES (1, 10, CURDATE()), (2, 10, CURDATE()); SELECT t0.id t0_id, t0.P1_01 t0_P1_01, t0.date t0_date, t1.id t1_id, t1.P1_01 t1_P1_01, t1.date t1_date FROM matches AS t0 LEFT OUTER JOIN matches AS t1 ON ( t0.id <> t1.id AND t0.P1_01 = t1.P1_01 ) WHERE DATE(t0.date) = CURDATE() AND DATE(t1.date) = CURDATE() ORDER BY t0.date ASC;
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear