INNER JOIN Возвращает пустой результат

CREATE TABLE `keys` (
  `id` INT(11) NOT NULL,
  `person_id` INT(11) NOT NULL,
  `date_creation` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `key_value` VARCHAR(32) COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 
 
CREATE TABLE `persons` (
  `id` INT(11) NOT NULL,
  `first_name` VARCHAR(25) COLLATE utf8_unicode_ci NOT NULL,
  `last_name` VARCHAR(25) COLLATE utf8_unicode_ci NOT NULL,
  `date_registration` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `city` VARCHAR(20) COLLATE utf8_unicode_ci NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

"SELECT `persons`.`id`, `persons`.`first_name`, `persons`.`last_name` FROM `persons` WHERE `id` NOT IN(SELECT `person_id` FROM `keys`)"

"SELECT `persons`.`id`, `persons`.`first_name`, `persons`.`last_name`, `keys`.`key_value` FROM `persons` WHERE `id` NOT IN(SELECT `person_id` FROM `keys`) INNER JOIN `keys` ON `persons`.`id` = `keys`.`person_id`"

SELECT `persons`.`id`, `persons`.`first_name`, `persons`.`last_name`, `keys`.`key_value` FROM `persons` WHERE `id` IN(SELECT `person_id` FROM `keys`) INNER JOIN `keys` ON `keys`.`person_id` = `persons`.`id`");