I have problems with Full Join connection.
For Example I have 2 identical tables:

*Table1 (Field1 I, Field2 B(2))
*Table2 (Field1 I, Field2 B(2))

And I want to make query:

SELECT ;
NVL(Table1.Field1, Table2.Field1) AS Field1, ;
NVL(Table1.Field2, 0) + NVL(Table2.Field2, 0) AS Field2 ;
FROM table1 ;
FULL JOIN table2 ;
ON table1.field1 = table2.field1 ;
GROUP BY field1

So, problem occurs when one of table has no records. Result has no records too when another table has more than one.
Full join works when both tables have records.
What's the matter?

Giedrius