>Have two tables that have some of the same fields. I want to look at a specific record in table 1 and find out what field values are not the same as table 2. I don't care about fields that are not the same between the tables. The fields may or may not be in the same order within the two tables. Any thoughts?
Using afields() you could create a string for the common field list - (say lCCommonFields: "f1,f2,f3").
select 1 as _source,&lcCommonFields from t1 ;
union ;
select 2 as _source,&lcCommonFields from t2 ;
into cursor temp nofilter
lcGrpBy = ''
For ix=2 To Fcount()
lcGrpBy = m.lcGrpBy + Iif(Empty(m.lcGrpBy),'',',')+Transform(m.ix)
Endfor
select * from temp ;
having sum(_source) # 3 group by &lcGroupBy
Cetin