Hi,

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.

Thanks,
Dion.

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