Subject Join Table with self
Author Dion Oliphant

Is it possible to join a table with itself as follows:-

SELECT * FROM GenLedger a
JOIN GenLedger b ON a.TransRef = b.TransRef
AND a.Actn='C'

I run out of memory when I run this query.


Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (
Version: 6.0.365 / Virus Database: 202 - Release Date: 05/24/2002