create table `shops`(
  `name` varchar (255),
    CONSTRAINT `shops_pr` primary key (`name`)
);
create table `users` (
  `id` int ,
  `name` varchar (255),
    CONSTRAINT `users_pr` primary key (`name`)
);
create table `shop` (
  `shop` varchar (255) ,
  `user` varchar (255) ,
   CONSTRAINT `shop_fk` FOREIGN KEY (`shop`) REFERENCES `shops`(`name`),
   CONSTRAINT `shop_fk2` FOREIGN KEY (`user`) REFERENCES `users` (`name`)
);
insert into `shops`  (`name`) values ('Azaz');
insert into `shops`  (`name`) values ('Efrin');
insert into `shops`  (`name`) values ('bzaa');
insert into `shops`  (`name`) values ('ksa');

insert into `users` (`id`,`name`) values (1,'Ahmed');
insert into `users` (`id`,`name`) values (2,'Osama');
insert into `users` (`id`,`name`) values (3,'Ali');
insert into `users` (`id`,`name`) values (4,'Elzero');
insert into `users` (`id`,`name`) values (5,'aya');
insert into `users` (`id`,`name`) values (6,'Husam');

insert into `shop` (`shop`,`user`) values ('ksa','Ali');
insert into `shop` (`shop`,`user`) values ('bzaa','Ali');
insert into `shop` (`shop`,`user`) values ('Azaz','Ali');
insert into `shop` (`shop`,`user`) values ('ksa','Osama');
insert into `shop` (`shop`,`user`) values ('Efrin','Osama');
insert into `shop` (`shop`,`user`) values ('Azaz','Elzero');
insert into `shop` (`shop`,`user`) values ('bzaa','Elzero');
-- select * from `shop`
-- JOIN `users` ON
-- `users`.`name`=`shop`.`user`
-- JOIN `shops` ON
-- `shops`.`name`=`shop`.`shop`
-- ;
-- select * from `shop`,`shops`,`users`
-- WHERE `shops`.`name`=`shop`.`shop` AND `users`.`name` = `shop`.`user`
-- SELECT * FROM `users` 
-- JOIN `shop` ON
-- `users`.`name`=`shop`.`user` 
-- WHERE `users`.`name`='Elzero'
SELECT * FROM `shops`
JOIN `shop` ON
`shops`.`name`=`shop`.`shop`
WHERE `shops`.`name`='ksa'