General information
Category:
Coding, syntax & commands
Title:
Select from 2 tables
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only