Hi Dion!

I tried something similar to your query in IB_SQL (against a Firebird 1.0
database):

SELECT * FROM RDB$DATABASE A
JOIN RDB$DATABASE B
ON A.RDB$RELATION_ID = B.RDB$RELATION_ID
WHERE A.RDB$CHARACTER_SET_NAME = 'ISO8859_1'

and it returned the one doubled record (* selects from both tables) as
expected (it also worked when I changed the WHERE to AND).

I guess you running out of memory is due to whatever tool you are using
(remember always to state such things with problems such as yours). Also
remember that a selfreferencing query such as yours may return a lot of
rows if many records have the same values for the fields mentioned.

Set