Sqlstate= 42908; Spaltenliste erforderlich

[Andreas_Prouza]

Hi,

mach's so:
CREATE TABLE QTEMP/TmpFILE (FIELD1, FIELD2, ITEMTEXT) AS
(SELECT FIELD1, FIELD2, IfNull(FIELD3, 'not found in FILE2')
as ITEMTEXT
FROM FILE1 LEFT OUTER JOIN FILE2
ON KEY1 = KEY1
ORDER BY FIELD1)
WITH DATA