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

Click here to load this message in the networking platform