Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Update table with query
Message
De
14/11/2016 00:17:33
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Update table with query
Versions des environnements
Visual FoxPro:
VFP 9
OS:
Windows 7
Network:
Windows XP
Database:
MS SQL Server
Application:
Desktop
Divers
Thread ID:
01643334
Message ID:
01643334
Vues:
39
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform