join

create table t_join_buyers
(
buyer_name varchar(10),
buyer_id int
)

create table t_join_sales
(
buyer_id int,
prod_id int,
qty int
)


insert into t_join_buyers values (‘jack‘,1)
insert into t_join_buyers values (‘tom‘,2)
insert into t_join_buyers values (‘anni‘,3)
insert into t_join_buyers values (‘poly‘,4)

insert into t_join_sales  values (1,2,15)
insert into t_join_sales  values (1,3,5)
insert into t_join_sales  values (4,1,37)
insert into t_join_sales  values (3,5,11)
insert into t_join_sales  values (4,2,1003)