>In the SQL below, I'm using TransHist.iTransact to determine whether I want a result record or not. What I really need is to know if the exact record does not exist in TransHist, not just by using the iTransact field value. The same fields exist in the crsTestAcctContiUniCont cursor and the TransHist table. How would I do this?
>
>
>

>SELECT * ;
>	FROM crsTestAcctContiUniCont;
>	WHERE crsTestAcctContiUniCont.iTransact NOT IN (SELECT iTransact FROM TransHist) ;
>	INTO CURSOR crsUpdate
>

Jay,
You might do something like this (wouldn't work if data has memo,general):

Select *,1 As _Src From c1 ;
  union ;
  Select *,2 As _Src From c2 ;
  into Cursor CrsU

lcGrpBy = ''
For ix=1 To Fcount()-1
  lcGrpBy = m.lcGrpBy + Iif(Empty(m.lcGrpBy),'',',')+Transform(m.ix)
Endfor

Select * From CrsU ;
  having Sum(_Src) = 1 ;
  group By &lcGrpBy

Cetin