Re: SELECT with no FROM?

On V5R4 I have

DECLARE GLOBAL TEMPORARY TABLE TempTable

(First VARCHAR(50), Middle VARCHAR(50), Last
VARCHAR(50))
Table TEMPTABLE created in QTEMP.

INSERT INTO QTEMP/TEMPTABLE (FIRST, MIDDLE, LAST) VALUES('Foo',

'Bar', 'ForMe')
1 rows inserted in TEMPTABLE in QTEMP.

select first, middle, last from TempTable

union
select first, middle, last from employees

....+....1....+....2....+....3....+....4....+....5....+....6....+....7....+....8....+....9....+...10....+...11.
FIRST MIDDLE LAST
Foo Bar ForMe
Rob O Berendt
Samwise Son of Hamfast
Gamgee
******** End of data ********


Cute way to put column headings into a output file, by the way.

Rob Berendt