clear markdown feedback
clear markdown feedback
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 3364508 fiddles created (36227 in the last week).

CREATE TABLE a (i int);
 hidden batch(es)


CREATE TABLE b (i int);
 hidden batch(es)


INSERT INTO a(i) VALUES(1),(2),(3);
 hidden batch(es)


INSERT INTO b(i) VALUES(1),(2),(3);
 hidden batch(es)


select * from a ,b where a.i=b.i;
i i
1 1
2 2
3 3
 hidden batch(es)


select * from a ,b on a.i=b.i;
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'on a.i=b.i' at line 1
 hidden batch(es)