SELECT (`name`) as `key` FROM `car_model` WHERE `id_car_mark` = 157
UNION
SELECT (`name_rus`) as `key` FROM `car_model` WHERE `id_car_mark` = 157

SELECT `id_car_model` FROM `car_generation` WHERE `year_begin` > 1985

WHERE `year_begin` > 1985

CREATE TABLE `car_model` (
  `id_car_model` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `id_car_mark` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `date_create` int(10) unsigned DEFAULT NULL,
  `date_update` int(10) unsigned DEFAULT NULL,
  `id_car_type` int(8) NOT NULL,
  `name_rus` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id_car_model`),
  KEY `name` (`name`),
  KEY `id_car_mark` (`id_car_mark`),
  KEY `id_car_type` (`id_car_type`)
) ENGINE=MyISAM AUTO_INCREMENT=22476 DEFAULT CHARSET=utf8 COMMENT='Модели автомобилей';

CREATE TABLE `car_generation` (
  `id_car_generation` int(8) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `id_car_model` int(8) NOT NULL,
  `year_begin` varchar(255) DEFAULT NULL,
  `year_end` varchar(255) DEFAULT NULL,
  `date_create` int(10) unsigned NOT NULL,
  `date_update` int(10) unsigned DEFAULT NULL,
  `id_car_type` int(8) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id_car_generation`),
  KEY `id_car_model` (`id_car_model`),
  KEY `id_car_type` (`id_car_type`)
) ENGINE=MyISAM AUTO_INCREMENT=107936 DEFAULT CHARSET=utf8 COMMENT='Поколения Моделей';

SELECT a.name, a.name_rus, a.id_car_mark FROM `car_model` as a, `car_generation` as b WHERE a.id_car_mark = 10 OR a.id_car_model = b.id_car_model;

SELECT a.name, a.name_rus, a.id_car_mark FROM `car_model` as a, `car_generation` as b WHERE a.id_car_mark = 10 OR b.year_begin > 1985;

SELECT a.name, a.name_rus, a.id_car_mark, b.year_begin FROM `car_model` as a, `car_generation` as b WHERE a.id_car_model = b.id_car_model GROUP BY a.name;