SUMmarizing/GROUPing over UNION SELECT?

[Ivo]

Is it possible to summarize and group over a result set derived from 
several different tables using UNION SELECT?

For example, this is what I have:

Table1.field1

1
2
3
4
5
5
Table2.field1

1
2
3
3
And what I want to get is something like this:

1) SUM=29

2) A result set like this by grouping:

1
2
3
4
5
TIA,

Ivo Karindi



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]