-- Дамп структуры для таблица zap
CREATE TABLE IF NOT EXISTS `zap` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `fact_gorod_id` int(11) DEFAULT NULL,
  `zakazchik_id` int(11) DEFAULT NULL,
  `nomer` int(11) DEFAULT NULL,
  `opisanie` varchar(255) CHARACTER SET cp1251 DEFAULT NULL,
  `current_date_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `closed_date_time` timestamp NULL DEFAULT NULL,
  `srok_postavki` varchar(250) CHARACTER SET cp1251 DEFAULT NULL,
  `opened` int(11) DEFAULT NULL,
  `deleted` int(11) DEFAULT '0',
  `computer_insert` varchar(255) CHARACTER SET cp1251 DEFAULT NULL,
  `computer_edit` varchar(255) CHARACTER SET cp1251 DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

-- Дамп структуры для таблица zap_cen
CREATE TABLE IF NOT EXISTS `zap_cen` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `zap_id` int(11) DEFAULT NULL,
  `name` varchar(250) CHARACTER SET cp1251 DEFAULT NULL,
  `opisanie` varchar(250) CHARACTER SET cp1251 DEFAULT NULL,
  `edizm_id` int(11) DEFAULT NULL,
  `kol` int(11) DEFAULT NULL,
  `current_date_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `deleted` int(11) DEFAULT '0',
  `computer_insert` varchar(255) CHARACTER SET cp1251 DEFAULT NULL,
  `computer_edit` varchar(255) CHARACTER SET cp1251 DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=18 DEFAULT CHARSET=latin1;

-- Дамп структуры для таблица zap_otv
CREATE TABLE IF NOT EXISTS `zap_otv` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `zap_cen_id` int(11) DEFAULT NULL,
  `postavshik_id` int(11) DEFAULT NULL,
  `cena` double DEFAULT NULL,
  `opisanie` varchar(250) CHARACTER SET cp1251 DEFAULT NULL,
  `current_date_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `deleted` int(11) DEFAULT '0',
  `computer_insert` varchar(255) CHARACTER SET cp1251 DEFAULT NULL,
  `computer_edit` varchar(255) CHARACTER SET cp1251 DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=86 DEFAULT CHARSET=latin1;



Делаю выборку

SELECT 
zap_cen.id, 
zap_cen.zap_id, 
zap_otv.postavshik_id,
zap_cen.name, 
zap_cen.opisanie, 
edizm.name, 
zap_cen.kol, 
zap_otv.cena, 
zap_otv.opisanie, 
zap_otv.deleted
FROM 
edizm INNER JOIN 
(zap_cen LEFT JOIN zap_otv ON 
zap_cen.id = zap_otv.zap_cen_id) ON
edizm.id = zap_cen.edizm_id
WHERE 
(zap_cen.zap_id=2) AND 
(zap_otv.postavshik_id=2) AND 
(zap_otv.deleted=0)
order by zap_cen.id;