MySQL - spojení tabulek s podmínkou

CREATE TABLE `zabery` (
  `id` int(6) NOT NULL auto_increment,
  `projekt` int(5) NOT NULL,
  `povoleni` set('a','n') NOT NULL,
  `poradi` int(6) NOT NULL,
  `epizoda` varchar(50) NOT NULL,
  `klapka` varchar(50) NOT NULL,
  `rec_tc` varchar(20) NOT NULL,
  `popis` varchar(200) NOT NULL,
  `check` set('a','n') NOT NULL,
  `hodnoceni` set('1','2','3') NOT NULL,
  `nat_den` int(5) NOT NULL,
  `prostredi` varchar(60) NOT NULL,
  `datum` varchar(10) NOT NULL,
  `role` varchar(20) NOT NULL,
  `zdroj` varchar(50) NOT NULL,
  `format` varchar(50) NOT NULL,
  `asyn_tc` set('a','n') NOT NULL,
  `reel` int(3) NOT NULL,
  `ciszab` varchar(15) NOT NULL,
  `zaber_ozn` varchar(10) NOT NULL,
  `in_tc` int(6) NOT NULL,
  `out_tc` int(6) NOT NULL,
  `stav` varchar(50) NOT NULL,
  `fps` varchar(5) NOT NULL,
  `vytvoreno` varchar(16) NOT NULL,
  `zadal` varchar(50) NOT NULL,
  `zmena` varchar(16) NOT NULL,
  `zmenil` varchar(50) NOT NULL,
  `znacka` varchar(100) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=239 ;

CREATE TABLE `soubory` (
  `ident` int(6) NOT NULL auto_increment,
  `projekt` int(6) NOT NULL,
  `zaber` int(6) NOT NULL,
  `poradi` int(6) NOT NULL,
  `nazev` varchar(100) NOT NULL,
  `pripona` varchar(10) NOT NULL,
  `umisteni` varchar(20) NOT NULL,
  `adresar` varchar(100) NOT NULL,
  KEY `id` (`ident`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=101 ;

SELECT * FROM zabery LEFT JOIN soubory ON soubory.zaber = zabery.ciszab WHERE soubory.umisteni = 'title'

SELECT * FROM zabery LEFT JOIN soubory ON soubory.projekt = zabery.projekt
AND soubory.zaber = zabery.ciszab
AND soubory.umisteni = 'title' WHERE zabery.povoleni = 'a' AND zabery.projekt = '1'