Yes

Your From part needs to look like this

FROM
GenLedger A ,
GenLedger B

Dion Oliphant wrote:

> 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).
> <http://www.grisoft.com%29.>
> Version: 6.0.365 / Virus Database: 202 - Release Date: 05/24/2002
>
>
>
> *Yahoo! Groups Sponsor*
> ADVERTISEMENT
> <http://rd.yahoo.com/M=226014.2032696.3508022.1829184/D=egroupweb/S=1705115386:HM/A=1000239/R=0/*http://ads.x10.com/?bHlhaG9vaG0xLmRhd=1023719491%3eM=226014.2032696.3508022.1829184/D=egroupweb/S=1705115386:HM/A=1000239/R=1>
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
> <http://docs.yahoo.com/info/terms/>.

--
Thomas Miller
Delphi Client/Server Certified Developer
BSS Accounting & Distribution Software
BSS Enterprise Accounting FrameWork

http://www.bss-software.com




[Non-text portions of this message have been removed]