MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select version();


version()


8.0.27


create table products (product_id int, product_name varchar(10), pack_size varchar(10));
create table buyers (buyername varchar(10));
create table newtable(product_id int, product_name varchar(10), pack_size varchar(10), buyer_name varchar(10));
insert into products values(1,'Eggs','1*3'),(2,'Milk',3*3),(3,'Fish','4 Boxes');

insert into buyers values ('A'),('B'),('C');
insert into newtable
select t1.*,t2.buyername from products t1 join buyers t2
select * from newtable order by product_id


product_id
product_name
pack_size
buyer_name


1
Eggs
1*3
A

1
Eggs
1*3
B

1
Eggs
1*3
C

2
Milk
9
A

2
Milk
9
B

2
Milk
9
C

3
Fish
4 Boxes
A

3
Fish
4 Boxes
B

3
Fish
4 Boxes
C

product_id	product_name	pack_size	buyer_name
1	Eggs	1*3	A
1	Eggs	1*3	B
1	Eggs	1*3	C
2	Milk	9	A
2	Milk	9	B
2	Milk	9	C
3	Fish	4 Boxes	A
3	Fish	4 Boxes	B
3	Fish	4 Boxes	C