Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Update table with query
Message
From
14/11/2016 00:17:33
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Update table with query
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows 7
Network:
Windows XP
Database:
MS SQL Server
Application:
Desktop
Miscellaneous
Thread ID:
01643334
Message ID:
01643334
Views:
38
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
Reply
Map
View

Click here to load this message in the networking platform