Dear Experts.
I have folloiwng data
create cursor products (code c(2),names c(10))
insert into products values ('11','Apple')
insert into products values ('12','Mango')
insert into products values ('13','Grapes')
insert into products values ('14','Banana')
insert into products values ('15','Guava')
create cursor sales (code c(2),qty n(4))
insert into sales values ('11',15)
insert into sales values ('12',121)
insert into sales values ('13',830)
insert into sales values ('14',1125)
insert into sales values ('15',1800)
With select statement, I need reuslt like this
code-names-qty
11--Apple----15
12--Mango--121
13--Grapes--830
14--Banana-1125
15--Guava---1800
Do not want to use update command