DROP TABLE IF EXISTS `B`;
CREATE TABLE `B` (
  `pk` int(11) NOT NULL AUTO_INCREMENT,
  `int_nokey` int(11) NOT NULL,
  `int_key` int(11) NOT NULL,
  `date_key` date NOT NULL,
  `date_nokey` date NOT NULL,
  `time_key` time NOT NULL,
  `time_nokey` time NOT NULL,
  `datetime_key` datetime NOT NULL,
  `datetime_nokey` datetime NOT NULL,
  `varchar_key` varchar(1) NOT NULL,
  `varchar_nokey` varchar(1) NOT NULL,
  PRIMARY KEY (`pk`),
  KEY `int_key` (`int_key`),
  KEY `date_key` (`date_key`),
  KEY `time_key` (`time_key`),
  KEY `datetime_key` (`datetime_key`),
  KEY `varchar_key` (`varchar_key`)
) ENGINE=Falcon;

INSERT INTO `B` VALUES (1,8,5,'0000-00-00','0000-00-00','10:37:38','10:37:38','0000-00-00 00:00:00','0000-00-00 00:00:00','p','p'),(2,0,9,'0000-00-00','0000-00-00','00:00:00','00:00:00','2007-10-14 00:00:00','2007-10-14 00:00:00','d','d');

DROP TABLE IF EXISTS `C`;
CREATE TABLE `C` (
  `pk` int(11) NOT NULL AUTO_INCREMENT,
  `int_nokey` int(11) NOT NULL,
  `int_key` int(11) NOT NULL,
  `date_key` date NOT NULL,
  `date_nokey` date NOT NULL,
  `time_key` time NOT NULL,
  `time_nokey` time NOT NULL,
  `datetime_key` datetime NOT NULL,
  `datetime_nokey` datetime NOT NULL,
  `varchar_key` varchar(1) NOT NULL,
  `varchar_nokey` varchar(1) NOT NULL,
  PRIMARY KEY (`pk`),
  KEY `int_key` (`int_key`),
  KEY `date_key` (`date_key`),
  KEY `time_key` (`time_key`),
  KEY `datetime_key` (`datetime_key`),
  KEY `varchar_key` (`varchar_key`)
) ENGINE=Falcon;

INSERT INTO `C` VALUES (1,1,6,'2005-12-23','2005-12-23','02:24:28','02:24:28','0000-00-00 00:00:00','0000-00-00 00:00:00','g','g'),(2,0,3,'2009-09-14','2009-09-14','00:00:00','00:00:00','2000-01-30 16:39:40','2000-01-30 16:39:40','q','q'),(3,0,3,'0000-00-00','0000-00-00','00:00:00','00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00','c','c'),(4,1,6,'2007-03-29','2007-03-29','15:49:00','15:49:00','0000-00-00 00:00:00','0000-00-00 00:00:00','m','m'),(5,4,0,'2002-12-04','2002-12-04','00:00:00','00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00','o','o'),(6,9,0,'2005-01-28','2005-01-28','00:00:00','00:00:00','2001-05-18 00:00:00','2001-05-18 00:00:00','w','w'),(7,6,0,'0000-00-00','0000-00-00','06:57:25','06:57:25','0000-00-00 00:00:00','0000-00-00 00:00:00','m','m'),(8,0,0,'0000-00-00','0000-00-00','00:00:00','00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00','z','z'),(9,4,6,'2006-08-15','2006-08-15','00:00:00','00:00:00','2002-04-12 14:44:25','2002-04-12 14:44:25','j','j'),(10,0,5,'2006-12-20','2006-12-20','10:13:53','10:13:53','2008-07-22 00:00:00','2008-07-22 00:00:00','y','y'),(11,9,7,'0000-00-00','0000-00-00','00:00:00','00:00:00','2004-07-05 00:00:00','2004-07-05 00:00:00','{','{'),(12,4,3,'2007-01-26','2007-01-26','23:00:51','23:00:51','2001-05-16 00:00:00','2001-05-16 00:00:00','f','f'),(13,7,0,'2004-03-27','2004-03-27','00:00:00','00:00:00','2005-01-24 03:30:37','2005-01-24 03:30:37','',''),(14,6,0,'2006-07-26','2006-07-26','18:43:57','18:43:57','0000-00-00 00:00:00','0000-00-00 00:00:00','{','{'),(15,0,6,'2000-01-14','2000-01-14','00:00:00','00:00:00','2000-09-21 00:00:00','2000-09-21 00:00:00','o','o'),(16,9,8,'0000-00-00','0000-00-00','21:15:08','21:15:08','0000-00-00 00:00:00','0000-00-00 00:00:00','a','a'),(17,2,0,'2004-10-27','2004-10-27','00:00:00','00:00:00','2004-03-24 22:13:43','2004-03-24 22:13:43','',''),(18,7,4,'0000-00-00','0000-00-00','08:38:27','08:38:27','2002-03-18 19:51:44','2002-03-18 19:51:44','t','t'),(19,5,3,'2008-03-07','2008-03-07','03:29:07','03:29:07','2007-12-01 18:44:44','2007-12-01 18:44:44','t','t'),(20,0,0,'2002-04-09','2002-04-09','16:06:03','16:06:03','2009-04-22 00:00:00','2009-04-22 00:00:00','n','n');

DROP TABLE IF EXISTS `CC`;
CREATE TABLE `CC` (
  `pk` int(11) NOT NULL AUTO_INCREMENT,
  `int_nokey` int(11) NOT NULL,
  `int_key` int(11) NOT NULL,
  `date_key` date NOT NULL,
  `date_nokey` date NOT NULL,
  `time_key` time NOT NULL,
  `time_nokey` time NOT NULL,
  `datetime_key` datetime NOT NULL,
  `datetime_nokey` datetime NOT NULL,
  `varchar_key` varchar(1) NOT NULL,
  `varchar_nokey` varchar(1) NOT NULL,
  PRIMARY KEY (`pk`),
  KEY `int_key` (`int_key`),
  KEY `date_key` (`date_key`),
  KEY `time_key` (`time_key`),
  KEY `datetime_key` (`datetime_key`),
  KEY `varchar_key` (`varchar_key`)
) ENGINE=Falcon;

INSERT INTO `CC` VALUES (10,4,2,'0000-00-00','0000-00-00','00:47:47','00:47:47','2006-03-18 00:00:00','2006-03-18 00:00:00','',''),(11,1,0,'2004-04-22','2004-04-22','00:00:00','00:00:00','2009-09-20 18:52:05','2009-09-20 18:52:05','y','y'),(12,7,0,'0000-00-00','0000-00-00','22:24:06','22:24:06','0000-00-00 00:00:00','0000-00-00 00:00:00','y','y'),(13,4,0,'2003-03-15','2003-03-15','16:38:08','16:38:08','2001-02-15 10:17:29','2001-02-15 10:17:29','w','w'),(14,9,8,'2003-11-26','2003-11-26','00:00:00','00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00','n','n'),(15,4,0,'2005-06-11','2005-06-11','00:00:00','00:00:00','2003-08-14 18:35:30','2003-08-14 18:35:30','a','a'),(16,0,0,'0000-00-00','0000-00-00','15:47:46','15:47:46','0000-00-00 00:00:00','0000-00-00 00:00:00','p','p'),(17,9,0,'0000-00-00','0000-00-00','15:49:08','15:49:08','0000-00-00 00:00:00','0000-00-00 00:00:00','w','w'),(18,0,0,'2003-05-06','2003-05-06','00:00:00','00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00','t','t'),(19,4,1,'2003-05-18','2003-05-18','00:00:00','00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00','q','q'),(20,8,7,'0000-00-00','0000-00-00','00:00:00','00:00:00','2003-04-18 21:56:02','2003-04-18 21:56:02','o','o'),(21,9,4,'0000-00-00','0000-00-00','04:02:24','04:02:24','2009-12-24 00:00:00','2009-12-24 00:00:00','v','v'),(22,2,0,'2009-02-20','2009-02-20','00:00:00','00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00','',''),(23,6,3,'2005-11-13','2005-11-13','00:00:00','00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00','h','h'),(24,9,0,'2009-10-25','2009-10-25','14:35:13','14:35:13','2000-01-13 09:40:25','2000-01-13 09:40:25','g','g'),(25,1,3,'0000-00-00','0000-00-00','00:00:00','00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00','d','d'),(26,4,1,'2007-07-28','2007-07-28','00:00:00','00:00:00','2000-03-10 00:30:49','2000-03-10 00:30:49','z','z'),(27,3,0,'2003-08-01','2003-08-01','20:07:09','20:07:09','2002-11-08 12:53:36','2002-11-08 12:53:36','',''),(28,1,9,'0000-00-00','0000-00-00','21:11:55','21:11:55','2002-03-02 04:50:28','2002-03-02 04:50:28','i','i'),(29,3,4,'2000-07-15','2000-07-15','19:35:49','19:35:49','2000-12-19 15:50:00','2000-12-19 15:50:00','','');

SELECT OUTR . `varchar_nokey`
FROM C AS OUTR2
LEFT JOIN B AS OUTR
ON ( OUTR2 . `varchar_nokey` < OUTR . `varchar_nokey` )
WHERE OUTR . `varchar_nokey` IN (
 SELECT INNR . `varchar_key` AS Y FROM CC AS INNR
 WHERE INNR . `pk` >= 6
);