Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Update table with query
Message
De
14/11/2016 01:19:04
 
 
À
14/11/2016 00:17:33
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
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:
01643337
Vues:
66
This message has been marked as the solution to the initial question of the thread.
This should be very easy if you took the time to press F1 once in a while.
select products.code, products.names, sales.qty from products;
   inner join sales on products.code = sales.code
>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform