Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Aggregate sql statement against result of union statement

Status
Not open for further replies.
cazellnu

cazellnu

Technical User
Aug 15, 2002
41
CA
HI All

I'm currently using Pervasive SQL 8 and wonder if the feature would be available for the scenario below:

T1.C1 T2.C2
A 20
B 30
C 0

T2.C1 T2.C2
A 70
B 10

Result
A 90
B 40
C 0

The issue is if it is possible that I can link two tables together first then sum it according by the column C1.

Any help would be greatly apperciate... Thanks million
 
Status
Not open for further replies.

Similar threads

dgillz
  • Locked
  • Question
DDF Builder for Actian fka Pervasive SQL
Replies
3
Views
336
mirtheil
mirtheil
michellepace
  • Locked
  • Question
Basic SQL: Add column to select statement (ie value from another table)
Replies
1
Views
229
michellepace
michellepace
Tabled
  • Locked
  • Question
Periodically run an SQL update statement 1
Replies
9
Views
406
mirtheil
mirtheil
David Ford
  • Locked
  • Question
[pervasive][odbc client interface] Numeric value out of range. (#0) - MS Access and Sage 50
Replies
2
Views
168
David Ford
David Ford
soocallmebrady
  • Locked
  • Question
Pervasive SQL Update with Joins - Error: Unknown table or correlation name
Replies
0
Views
146
soocallmebrady
soocallmebrady

Part and Inventory Search

Sponsor

Back
Top