SELECT dat z jedné tabulky, která nemají záznam v druhé tabu

CREATE TABLE IF NOT EXISTS `certs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ser_cislo` int(11) NOT NULL,
  `pocatek` date NOT NULL,
  `konec` date NOT NULL,
  `id_typ` int(11) NOT NULL,
  `id_autority` int(11) NOT NULL,
  `id_user` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=10 ;

CREATE TABLE IF NOT EXISTS `revokace` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_cer` int(11) NOT NULL,
  `duvod` varchar(45) COLLATE utf8_czech_ci NOT NULL,
  `datum` date DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=1 ;