mysql on_MySql左右连接 ON AND 和 ON WHERE 的区别

CREATE TABLE `a` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`sid` int(11) NOT NULL,

`type` char(10) NOT NULL,

PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `a` (`id`, `sid`, `type`) VALUES (1, 1, 'a');

INSERT INTO `a` (`id`, `sid`, `type`) VALUES (2, 1, 'b');

INSERT INTO `a` (`id`, `sid`, `type`) VALUES (3, 2, 'c');

INSERT INTO `a` (`id`, `sid`, `type`) VALUES (4, 3, 'd');

CREATE TABLE `b` (

`sid` int(11) NOT NULL,

`remark` char(10) DEFAULT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `b` (`sid`, `remark`) VALUES (1, 'A');

INSERT INTO `b` (`sid`, `remark`) VALUES (2, 'A');

INSERT INTO `b` (`sid`, `remark`) VALUES (3, 'C');

INSERT INTO `b` (`sid`, `remark`) VALUES (4, 'D');