Re: selecting a date not in the range

[tan tan]

thanks for trying sir irek, but it doesnt create the desired result..


CREATE TABLE `table1` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`checkin` varchar(45) DEFAULT NULL,
`checkout` varchar(45) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8



CREATE TABLE `table2` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`date` varchar(45) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8

INSERT INTO `test`.`table1` (`checkin`, `checkout`) VALUES ('2012-01-01', '2012-01-15');

INSERT INTO `test`.`table2` (`date`) VALUES ('2012-01-01');

INSERT INTO `test`.`table2` (`date`) VALUES ('2012-01-03');

INSERT INTO `test`.`table2` (`date`) VALUES ('2012-01-05');

INSERT INTO `test`.`table2` (`date`) VALUES ('2012-01-06');

INSERT INTO `test`.`table2` (`date`) VALUES ('2012-01-08');

INSERT INTO `test`.`table2` (`date`) VALUES ('2012-01-10');

the given answer by mr irek doesnt not show any resultset. thanks