Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Select from 2 tables
Message
From
20/05/2002 15:25:36
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Select from 2 tables
Miscellaneous
Thread ID:
00659056
Message ID:
00659056
Views:
41
I have 2 tables as shown here.

Table1
Cell Widgets
A 2
B 1
E 2
D 1


Table2
Cell Widgets
A 1
C 2
D 1
C 1

I need get the distinct cells and a count of the number of widgets from each table. The result should be as follows.

Result.
Cell Widgets
A 3
B 1
C 3
D 2
E 2

Ideally, I would like to use more than 10 tables at once for this operation. There are other columns like widgets that I would like to sum up obviously, but I hope from this example I will be able to proceed further.

TIA.

Ramone.
Next
Reply
Map
View

Click here to load this message in the networking platform