sub query?

----SKEMA---
CREATE TABLE IF NOT EXISTS `transaksi` (
`id` INT(11) NOT NULL,
  `tr_date` DATE NOT NULL,
  `tr_stat` CHAR(1) NOT NULL DEFAULT 'D' COMMENT 'D,K,O'
) ;
INSERT INTO `transaksi` (`id`, `tr_date`, `tr_stat`) VALUES
(1, '2015-07-12', 'D'),
(2, '2015-07-12', 'K'),
(3, '2015-07-13', 'D'),
(4, '2015-07-14', 'D'),
(5, '2015-07-14', 'K'),
(6, '2015-07-15', 'O'),
(7, '2015-07-16', 'K'),
(8, '2015-07-12', 'D');
CREATE TABLE IF NOT EXISTS `trans_date` (
  `date` DATE NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;



INSERT INTO `trans_date` (`date`) VALUES
('2015-07-12'),
('2015-07-13'),
('2015-07-14'),
('2015-07-15'),
('2015-07-16');


----QUERY---
SELECT * FROM `trans_date`
WHERE  NOT EXISTS( SELECT * FROM transaksi
                 WHERE `date` = tr_date AND tr_stat IN('K') )