>>Hi,
>>
>>Sorry for the uncomplete message.
>>
>>You can loop all the fields in the table and generate a where staement.
>>
>>e.g
>>
>>FOR n = 1 to FCOUNT(TableB)
>> cWhere = cWhere + 'TableB.' + FIELD(n) + '= TableA.' + FIELD(n)
>>ENDFOR
>>
>>cStatement = 'SELECT B.* FROM TableB B, TableA A WHERE ' + cWhere
>>
>>&cStatement
>>
>>Wilson
>
>Error: SQL statement too long.
>
>I'm working with 200+ fields so the list of field names goes way over the 254 limit.
>
>Looks like I'm going to need to do a scan between the tables? Any other ides before I go that route? Anyone?
>
>Renoir

Renoir, you may use a simple way: scan your table A and table B, using

SCATTER NAME command and COMPOBJ() function.

Something like:

SELECT tableA
SCAN
	SCATTER NAME oTableArec
	SELECT tableB
	SCAN
		SCATTER NAME oTableBrec
		lMatch = COMPOBJ(oTableArec, oTableBrec)
		IF lMatch
			* do something
		ENDIF
	ENDSCAN
ENDSCAN