MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select version();


version()


8.0.18


CREATE TABLE `address` (
  `address_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`address_id`)
);

CREATE TABLE `store` (
  `store_id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
  `address_id` smallint(5) unsigned NOT NULL,
  `last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`store_id`),
  KEY `idx_fk_address_id` (`address_id`),
  CONSTRAINT `fk_store_address` FOREIGN KEY (`address_id`) REFERENCES `address` (`address_id`) ON DELETE RESTRICT ON UPDATE CASCADE
);

INSERT INTO `address` VALUES (1), (2);
INSERT INTO store VALUES
(1,1,'2006-02-15 04:57:12'),
(2,2,'2006-02-15 04:57:12');
select * from store _0 where (
    select address_id from (
        select * from address _3 where (
            address_id = (
                select address_id from (
                    select * from store _1
                    where store_id=_0.store_id
                ) _2
            )
        )
    ) _4
);

select * from store _0 where (
    select address_id from (
        select * from address _3 where (
            address_id = (
		select address_id from store _1
		where store_id=_0.store_id
            )
        )
    ) _4
);


store_id
address_id
last_update


1
1
2006-02-15 04:57:12

2
2
2006-02-15 04:57:12