CREATE TABLE `t1` ( `pk` int(11) NOT NULL AUTO_INCREMENT, `col_int_nokey` int(11) NOT NULL, `col_int_key` int(11) NOT NULL, `col_varchar_key` varchar(1) NOT NULL, `col_varchar_nokey` varchar(1) NOT NULL, PRIMARY KEY (`pk`), KEY `col_int_key` (`col_int_key`), KEY `col_varchar_key` (`col_varchar_key`,`col_int_key`) ) ENGINE=MyISAM AUTO_INCREMENT=30 DEFAULT CHARSET=latin1; INSERT INTO `t1` VALUES (13,2,8,'s','s'); INSERT INTO `t1` VALUES (15,0,6,'p','p'); INSERT INTO `t1` VALUES (16,8,7,'z','z'); INSERT INTO `t1` VALUES (19,5,7,'h','h'); INSERT INTO `t1` VALUES (21,2,9,'v','v'); INSERT INTO `t1` VALUES (22,33,142,'b','b'); INSERT INTO `t1` VALUES (23,5,3,'y','y'); INSERT INTO `t1` VALUES (24,1,0,'v','v'); INSERT INTO `t1` VALUES (25,9,3,'m','m'); INSERT INTO `t1` VALUES (26,1,5,'z','z'); INSERT INTO `t1` VALUES (27,3,9,'n','n'); INSERT INTO `t1` VALUES (28,8,1,'d','d'); INSERT INTO `t1` VALUES (29,231,107,'a','a'); CREATE TABLE `t2` ( `pk` int(11) NOT NULL AUTO_INCREMENT, `col_int_nokey` int(11) NOT NULL, `col_int_key` int(11) NOT NULL, `col_varchar_key` varchar(1) NOT NULL, `col_varchar_nokey` varchar(1) NOT NULL, PRIMARY KEY (`pk`), KEY `col_int_key` (`col_int_key`), KEY `col_varchar_key` (`col_varchar_key`,`col_int_key`) ) ENGINE=MyISAM AUTO_INCREMENT=21 DEFAULT CHARSET=latin1; INSERT INTO `t2` VALUES (3,6,1,'o','o'); INSERT INTO `t2` VALUES (4,7,0,'g','g'); INSERT INTO `t2` VALUES (5,0,1,'v','v'); INSERT INTO `t2` VALUES (6,97,190,'m','m');
SELECT table1 .`col_int_nokey`,( SELECT MIN( SUBQUERY1_t1 .`col_int_key` ) FROM t2 SUBQUERY1_t1 JOIN ( t2 SUBQUERY1_t2 JOIN t1 SUBQUERY1_t3 ON SUBQUERY1_t2 .`pk` ) ON SUBQUERY1_t3 .`col_varchar_nokey` = SUBQUERY1_t2 .`col_varchar_key` WHERE table1 .`col_int_nokey` ) FROM t1 table1 ;
SELECT MIN( SUBQUERY1_t1 .`col_int_key` ) FROM t2 SUBQUERY1_t1 JOIN ( t2 SUBQUERY1_t2 JOIN t1 SUBQUERY1_t3 ON SUBQUERY1_t2 .`pk` ) ON SUBQUERY1_t3 .`col_varchar_nokey` = SUBQUERY1_t2 .`col_varchar_key` WHERE rand()*0 != 0;
select rand()*0 != 0;
drop table t1, t2;
CREATE TABLE `t1` ( varchar_ nokey` varchar(1) NOT NULL, key`,`col_ int_key` ) 142,'b' ,'b'); 107,'a' ,'a'); varchar_ nokey` varchar(1) NOT NULL, key`,`col_ int_key` )
`pk` int(11) NOT NULL AUTO_INCREMENT,
`col_int_nokey` int(11) NOT NULL,
`col_int_key` int(11) NOT NULL,
`col_varchar_key` varchar(1) NOT NULL,
`col_
PRIMARY KEY (`pk`),
KEY `col_int_key` (`col_int_key`),
KEY `col_varchar_key` (`col_varchar_
) ENGINE=MyISAM AUTO_INCREMENT=30 DEFAULT CHARSET=latin1;
INSERT INTO `t1` VALUES (13,2,8,'s','s');
INSERT INTO `t1` VALUES (15,0,6,'p','p');
INSERT INTO `t1` VALUES (16,8,7,'z','z');
INSERT INTO `t1` VALUES (19,5,7,'h','h');
INSERT INTO `t1` VALUES (21,2,9,'v','v');
INSERT INTO `t1` VALUES (22,33,
INSERT INTO `t1` VALUES (23,5,3,'y','y');
INSERT INTO `t1` VALUES (24,1,0,'v','v');
INSERT INTO `t1` VALUES (25,9,3,'m','m');
INSERT INTO `t1` VALUES (26,1,5,'z','z');
INSERT INTO `t1` VALUES (27,3,9,'n','n');
INSERT INTO `t1` VALUES (28,8,1,'d','d');
INSERT INTO `t1` VALUES (29,231,
CREATE TABLE `t2` (
`pk` int(11) NOT NULL AUTO_INCREMENT,
`col_int_nokey` int(11) NOT NULL,
`col_int_key` int(11) NOT NULL,
`col_varchar_key` varchar(1) NOT NULL,
`col_
PRIMARY KEY (`pk`),
KEY `col_int_key` (`col_int_key`),
KEY `col_varchar_key` (`col_varchar_
) ENGINE=MyISAM AUTO_INCREMENT=21 DEFAULT CHARSET=latin1;
INSERT INTO `t2` VALUES (3,6,1,'o','o');
INSERT INTO `t2` VALUES (4,7,0,'g','g');
INSERT INTO `t2` VALUES (5,0,1,'v','v');
INSERT INTO `t2` VALUES (6,97,190,'m','m');
SELECT table1 .`col_int_nokey`,( nokey` = SUBQUERY1_t2 .`col_varchar_key`
SELECT MIN( SUBQUERY1_t1 .`col_int_key` )
FROM t2 SUBQUERY1_t1 JOIN ( t2 SUBQUERY1_t2 JOIN t1 SUBQUERY1_t3 ON SUBQUERY1_t2 .`pk` ) ON SUBQUERY1_t3 .`col_varchar_
WHERE table1 .`col_int_nokey` )
FROM t1 table1 ;
SELECT MIN( SUBQUERY1_t1 .`col_int_key` ) nokey` = SUBQUERY1_t2 .`col_varchar_key`
FROM t2 SUBQUERY1_t1 JOIN ( t2 SUBQUERY1_t2 JOIN t1 SUBQUERY1_t3 ON SUBQUERY1_t2 .`pk` ) ON SUBQUERY1_t3 .`col_varchar_
WHERE rand()*0 != 0;
select rand()*0 != 0;
drop table t1, t2;