>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 ?