G> SELECT AVG(FIELD1) FROM
 G> (
 G>     SELECT FIELD1 FROM TABLE1
 G>     UNION
 G>     SELECT FIELD1 FROM TABLE2
 G>     UNION
 G>     SELECT FIELD1 FROM TABLE3
 G> ) AS D
 G>