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