выборка join-where

CREATE  TABLE IF NOT EXISTS `personnel`.`tbl_practice` (
  `id` TINYINT(1) NOT NULL AUTO_INCREMENT ,
  `practice` VARCHAR(100) CHARACTER SET 'utf8' COLLATE 'utf8_general_ci' NOT NULL ,
  PRIMARY KEY (`id`) )
ENGINE = InnoDB DEFAULT CHARSET=utf8;
 
CREATE  TABLE IF NOT EXISTS `personnel`.`tbl_personnel` (
  `id` INT(11) NOT NULL AUTO_INCREMENT ,
  `surname` VARCHAR(45) CHARACTER SET 'utf8' COLLATE 'utf8_general_ci' NOT NULL ,
  `name` VARCHAR(45) CHARACTER SET 'utf8' COLLATE 'utf8_general_ci' NOT NULL ,
  `patronymic` VARCHAR(45) CHARACTER SET 'utf8' COLLATE 'utf8_general_ci' NOT NULL ,
  `email` VARCHAR(150) CHARACTER SET 'utf8' COLLATE 'utf8_general_ci' NOT NULL ,
  `date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ,
  `practice_id` TINYINT(1) NULL ,
  `comment` TEXT CHARACTER SET 'utf8' COLLATE 'utf8_general_ci' NULL DEFAULT NULL ,
  PRIMARY KEY (`id`) ,
  INDEX `fk_tbl_personnel_tbl_practice_idx` (`practice_id` ASC) ,
  CONSTRAINT `fk_tbl_personnel_tbl_practice`
    FOREIGN KEY (`practice_id` )
    REFERENCES `personnel`.`tbl_practice` (`id` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB DEFAULT CHARSET=utf8;
 
CREATE  TABLE IF NOT EXISTS `personnel`.`tbl_skill` (
  `id` TINYINT(1) NOT NULL AUTO_INCREMENT ,
  `skill` VARCHAR(100)CHARACTER  SET 'utf8' COLLATE 'utf8_general_ci' NOT NULL ,
  PRIMARY KEY (`id`) )
ENGINE = InnoDB DEFAULT CHARSET=utf8;
 
CREATE  TABLE IF NOT EXISTS `personnel`.`tbl_personnel_skill` (
  `personnel_id` INT(11) NOT NULL ,
  `skill_id` TINYINT(1) NOT NULL ,
  PRIMARY KEY (`personnel_id`, `skill_id`) ,
  INDEX `fk_tbl_personnel_has_tbl_skill_tbl_skill1_idx` (`skill_id` ASC) ,
  INDEX `fk_tbl_personnel_has_tbl_skill_tbl_personnel1_idx` (`personnel_id` ASC) ,
  CONSTRAINT `fk_tbl_personnel_skill_tbl_personnel1`
    FOREIGN KEY (`personnel_id` )
    REFERENCES `personnel`.`tbl_personnel` (`id` )
    ON DELETE CASCADE
    ON UPDATE RESTRICT,
  CONSTRAINT `fk_tbl_personnel_skill_tbl_skill1`
    FOREIGN KEY (`skill_id` )
    REFERENCES `personnel`.`tbl_skill` (`id` )
    ON DELETE CASCADE
    ON UPDATE RESTRICT)
ENGINE = InnoDB DEFAULT CHARSET=utf8;
 
INSERT INTO `personnel`.`tbl_practice`(`id`, `practice`)
    VALUES  (NULL, 'без опыта'),
            (NULL, 'до 1 года'),
            (NULL, '1-3 года'),
            (NULL, '3-5 лет'),
            (NULL, 'более 5 лет');
 
INSERT INTO `personnel`.`tbl_skill`(`id`, `skill`)
    VALUES  (NULL, 'менеджмент'),
            (NULL, 'программирование'),
            (NULL, 'тестирование'),
            (NULL, 'дизайн');
 
INSERT INTO `personnel`.`tbl_personnel`(`id`, `surname`, `name`, `patronymic`, `email`, `date`, `practice_id`, `comment`)
    VALUES  (NULL, 'Иванов', 'Иван', 'Иванович', 'ivan@site.com', NULL, 1, ''),
            (NULL, 'Петров', 'Петр', 'Петрович', 'petr@site.com', NULL, 2, 'художник'),
            (NULL, 'Сидоров', 'Сидор', 'Сидорович', 'sidor@site.com', NULL, 3, 'программист'),
            (NULL, 'Сергеев', 'Сергей', 'Сергеевич', 'sergey@site.com', NULL, 4, 'мастер на все руки');
 
INSERT INTO `personnel`.`tbl_personnel_skill`(`personnel_id`, `skill_id`)
    VALUES  (1, 1),
            (2, 4),
            (3, 2),
            (3, 3),
            (4, 2),
            (4, 3),
            (4, 4);