>Lots of records in iAccts with a unique field of Acct_ID. I need to get the four fields from the other tables, but only if they are contained in the iAccts table. The Disclosure field is a memo. The SQL will not allow me to use DISTINCT or GROUP BY. Do I need to do a nested SQL to get this? Sometimes I hate the ENGINEBEHAVIOR 80, but I have to use it.
>
>
>

>SELECT DISTINCT ;
>	00000 AS FootNote, ;
>	FundDisclosures.DiscID, ;
>	DisclosureList.disctitle, ;
>	DisclosureList.disclosure ;
>	FROM D:\Development\2434_Disclaimer\iAccts ;
>	JOIN D:\Development\2434_Disclaimer\FundDisclosures ON FundDisclosures.Acct_ID == iAccts.Acct_ID ;
>	JOIN D:\Development\2434_Disclaimer\DisclosureList ON DisclosureList.discid == FundDisclosures.discid ;
>	INTO CURSOR crsFundDisclaimers READWRITE
>

personally, I'm a believer in chunking SQL queries when they get too complicated for me to do in an hour :)

How about dividing the task into 2, using temp tables and then do a SQL on the 2 temps ?