Message
From
14/11/2016 00:17:33
 
 
To
Todo
General information
Fórum:
Visual FoxPro
Category:
Bases de dados, Tabelas, Views, Indices e SQL
Título:
Update table with query
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows 7
Network:
Windows XP
Database:
MS SQL Server
Application:
Desktop
Miscellaneous
ID da thread:
01643334
ID da mensagem:
01643334
Views:
40
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
Next
Responder
Mapa
View