DROP TABLE IF EXISTS `sPa`; DROP TABLE IF EXISTS `sPb`; DROP TABLE IF EXISTS `sQa`; DROP TABLE IF EXISTS `sQb`; DROP TABLE IF EXISTS `sRa`; DROP TABLE IF EXISTS `sRb`; DROP TABLE IF EXISTS `sSa`; DROP TABLE IF EXISTS `sSb`; DROP TABLE IF EXISTS `sTa`; DROP TABLE IF EXISTS `sTb`; DROP TABLE IF EXISTS `sUa`; DROP TABLE IF EXISTS `sUb`; DROP TABLE IF EXISTS `sVa`; DROP TABLE IF EXISTS `sVb`; DROP TABLE IF EXISTS `sWa`; DROP TABLE IF EXISTS `sWb`; DROP TABLE IF EXISTS `sXa`; DROP TABLE IF EXISTS `sXb`; SET NAMES sjis; SET character_set_database = sjis; CREATE TABLE `sPa` (`bP` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = innodb; CREATE TABLE `sPb` (`bP` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = innodb; CREATE TABLE `sQa` (`bP` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = innodb; CREATE TABLE `sQb` (`bP` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = innodb; CREATE TABLE `sRa` (`bP` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = innodb; CREATE TABLE `sRb` (`bP` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = innodb; CREATE TABLE `sSa` (`bP` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = myisam; CREATE TABLE `sSb` (`bP` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = myisam; CREATE TABLE `sTa` (`bP` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = myisam; CREATE TABLE `sTb` (`bP` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = myisam; CREATE TABLE `sUa` (`bP` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = myisam; CREATE TABLE `sUb` (`bP` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = myisam; CREATE TABLE `sVa` (`bP` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = MEMORY; CREATE TABLE `sVb` (`bP` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = MEMORY; CREATE TABLE `sWa` (`bP` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = MEMORY; CREATE TABLE `sWb` (`bP` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = MEMORY; CREATE TABLE `sXa` (`bP` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = MEMORY; CREATE TABLE `sXb` (`bP` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = MEMORY; INSERT INTO `sPa` VALUES (''),(''),(''); INSERT INTO `sPb` VALUES (''); INSERT INTO `sQa` VALUES (''),(''),(''); INSERT INTO `sQb` VALUES (''); INSERT INTO `sRa` VALUES ('\'),('\'),('\'); INSERT INTO `sRb` VALUES ('\'); INSERT INTO `sSa` VALUES (''),(''),(''); INSERT INTO `sSb` VALUES (''); INSERT INTO `sTa` VALUES (''),(''),(''); INSERT INTO `sTb` VALUES (''); INSERT INTO `sUa` VALUES ('\'),('\'),('\'); INSERT INTO `sUb` VALUES ('\'); INSERT INTO `sVa` VALUES (''),(''),(''); INSERT INTO `sVb` VALUES (''); INSERT INTO `sWa` VALUES (''),(''),(''); INSERT INTO `sWb` VALUES (''); INSERT INTO `sXa` VALUES ('\'),('\'),('\'); INSERT INTO `sXb` VALUES ('\'); SELECT * FROM `sPa` JOIN `sPb`; bP bP SELECT * FROM `sPa` INNER JOIN `sPb`; bP bP SELECT * FROM `sPa` JOIN `sPb` USING (`bP`); bP SELECT * FROM `sPa` INNER JOIN `sPb` USING (`bP`); bP SELECT * FROM `sPa` CROSS JOIN `sPb`; bP bP SELECT * FROM `sPa` LEFT JOIN `sPb` USING (`bP`); bP SELECT * FROM `sPa` LEFT JOIN `sPb` ON (`sPa`.`bP` = `sPb`.`bP`); bP bP NULL NULL SELECT * FROM `sPb` RIGHT JOIN `sPa` USING (`bP`); bP SELECT * FROM `sPb` RIGHT JOIN `sPa` ON (`sPa`.`bP` = `sPb`.`bP`); bP bP NULL NULL SELECT * FROM `sQa` JOIN `sQb`; bP bP SELECT * FROM `sQa` INNER JOIN `sQb`; bP bP SELECT * FROM `sQa` JOIN `sQb` USING (`bP`); bP SELECT * FROM `sQa` INNER JOIN `sQb` USING (`bP`); bP SELECT * FROM `sQa` CROSS JOIN `sQb`; bP bP SELECT * FROM `sQa` LEFT JOIN `sQb` USING (`bP`); bP SELECT * FROM `sQa` LEFT JOIN `sQb` ON (`sQa`.`bP` = `sQb`.`bP`); bP bP NULL NULL SELECT * FROM `sQb` RIGHT JOIN `sQa` USING (`bP`); bP SELECT * FROM `sQb` RIGHT JOIN `sQa` ON (`sQa`.`bP` = `sQb`.`bP`); bP bP NULL NULL SELECT * FROM `sRa` JOIN `sRb`; bP bP \ \ \ \ \ \ SELECT * FROM `sRa` INNER JOIN `sRb`; bP bP \ \ \ \ \ \ SELECT * FROM `sRa` JOIN `sRb` USING (`bP`); bP \ SELECT * FROM `sRa` INNER JOIN `sRb` USING (`bP`); bP \ SELECT * FROM `sRa` CROSS JOIN `sRb`; bP bP \ \ \ \ \ \ SELECT * FROM `sRa` LEFT JOIN `sRb` USING (`bP`); bP \ \ \ SELECT * FROM `sRa` LEFT JOIN `sRb` ON (`sRa`.`bP` = `sRb`.`bP`); bP bP \ \ \ NULL \ NULL SELECT * FROM `sRb` RIGHT JOIN `sRa` USING (`bP`); bP \ \ \ SELECT * FROM `sRb` RIGHT JOIN `sRa` ON (`sRa`.`bP` = `sRb`.`bP`); bP bP \ \ NULL \ NULL \ SELECT * FROM `sSa` JOIN `sSb`; bP bP SELECT * FROM `sSa` INNER JOIN `sSb`; bP bP SELECT * FROM `sSa` JOIN `sSb` USING (`bP`); bP SELECT * FROM `sSa` INNER JOIN `sSb` USING (`bP`); bP SELECT * FROM `sSa` CROSS JOIN `sSb`; bP bP SELECT * FROM `sSa` LEFT JOIN `sSb` USING (`bP`); bP SELECT * FROM `sSa` LEFT JOIN `sSb` ON (`sSa`.`bP` = `sSb`.`bP`); bP bP NULL NULL SELECT * FROM `sSb` RIGHT JOIN `sSa` USING (`bP`); bP SELECT * FROM `sSb` RIGHT JOIN `sSa` ON (`sSa`.`bP` = `sSb`.`bP`); bP bP NULL NULL SELECT * FROM `sTa` JOIN `sTb`; bP bP SELECT * FROM `sTa` INNER JOIN `sTb`; bP bP SELECT * FROM `sTa` JOIN `sTb` USING (`bP`); bP SELECT * FROM `sTa` INNER JOIN `sTb` USING (`bP`); bP SELECT * FROM `sTa` CROSS JOIN `sTb`; bP bP SELECT * FROM `sTa` LEFT JOIN `sTb` USING (`bP`); bP SELECT * FROM `sTa` LEFT JOIN `sTb` ON (`sTa`.`bP` = `sTb`.`bP`); bP bP NULL NULL SELECT * FROM `sTb` RIGHT JOIN `sTa` USING (`bP`); bP SELECT * FROM `sTb` RIGHT JOIN `sTa` ON (`sTa`.`bP` = `sTb`.`bP`); bP bP NULL NULL SELECT * FROM `sUa` JOIN `sUb`; bP bP \ \ \ \ \ \ SELECT * FROM `sUa` INNER JOIN `sUb`; bP bP \ \ \ \ \ \ SELECT * FROM `sUa` JOIN `sUb` USING (`bP`); bP \ SELECT * FROM `sUa` INNER JOIN `sUb` USING (`bP`); bP \ SELECT * FROM `sUa` CROSS JOIN `sUb`; bP bP \ \ \ \ \ \ SELECT * FROM `sUa` LEFT JOIN `sUb` USING (`bP`); bP \ \ \ SELECT * FROM `sUa` LEFT JOIN `sUb` ON (`sUa`.`bP` = `sUb`.`bP`); bP bP \ \ \ NULL \ NULL SELECT * FROM `sUb` RIGHT JOIN `sUa` USING (`bP`); bP \ \ \ SELECT * FROM `sUb` RIGHT JOIN `sUa` ON (`sUa`.`bP` = `sUb`.`bP`); bP bP \ \ NULL \ NULL \ SELECT * FROM `sVa` JOIN `sVb`; bP bP SELECT * FROM `sVa` INNER JOIN `sVb`; bP bP SELECT * FROM `sVa` JOIN `sVb` USING (`bP`); bP SELECT * FROM `sVa` INNER JOIN `sVb` USING (`bP`); bP SELECT * FROM `sVa` CROSS JOIN `sVb`; bP bP SELECT * FROM `sVa` LEFT JOIN `sVb` USING (`bP`); bP SELECT * FROM `sVa` LEFT JOIN `sVb` ON (`sVa`.`bP` = `sVb`.`bP`); bP bP NULL NULL SELECT * FROM `sVb` RIGHT JOIN `sVa` USING (`bP`); bP SELECT * FROM `sVb` RIGHT JOIN `sVa` ON (`sVa`.`bP` = `sVb`.`bP`); bP bP NULL NULL SELECT * FROM `sWa` JOIN `sWb`; bP bP SELECT * FROM `sWa` INNER JOIN `sWb`; bP bP SELECT * FROM `sWa` JOIN `sWb` USING (`bP`); bP SELECT * FROM `sWa` INNER JOIN `sWb` USING (`bP`); bP SELECT * FROM `sWa` CROSS JOIN `sWb`; bP bP SELECT * FROM `sWa` LEFT JOIN `sWb` USING (`bP`); bP SELECT * FROM `sWa` LEFT JOIN `sWb` ON (`sWa`.`bP` = `sWb`.`bP`); bP bP NULL NULL SELECT * FROM `sWb` RIGHT JOIN `sWa` USING (`bP`); bP SELECT * FROM `sWb` RIGHT JOIN `sWa` ON (`sWa`.`bP` = `sWb`.`bP`); bP bP NULL NULL SELECT * FROM `sXa` JOIN `sXb`; bP bP \ \ \ \ \ \ SELECT * FROM `sXa` INNER JOIN `sXb`; bP bP \ \ \ \ \ \ SELECT * FROM `sXa` JOIN `sXb` USING (`bP`); bP \ SELECT * FROM `sXa` INNER JOIN `sXb` USING (`bP`); bP \ SELECT * FROM `sXa` CROSS JOIN `sXb`; bP bP \ \ \ \ \ \ SELECT * FROM `sXa` LEFT JOIN `sXb` USING (`bP`); bP \ \ \ SELECT * FROM `sXa` LEFT JOIN `sXb` ON (`sXa`.`bP` = `sXb`.`bP`); bP bP \ \ \ NULL \ NULL SELECT * FROM `sXb` RIGHT JOIN `sXa` USING (`bP`); bP \ \ \ SELECT * FROM `sXb` RIGHT JOIN `sXa` ON (`sXa`.`bP` = `sXb`.`bP`); bP bP \ \ NULL \ NULL \ DROP TABLE `sPa`; DROP TABLE `sPb`; DROP TABLE `sQa`; DROP TABLE `sQb`; DROP TABLE `sRa`; DROP TABLE `sRb`; DROP TABLE `sSa`; DROP TABLE `sSb`; DROP TABLE `sTa`; DROP TABLE `sTb`; DROP TABLE `sUa`; DROP TABLE `sUb`; DROP TABLE `sVa`; DROP TABLE `sVb`; DROP TABLE `sWa`; DROP TABLE `sWb`; DROP TABLE `sXa`; DROP TABLE `sXb`;