>oopps i forgot NAME clause:
>
>scatter name loname1
>
>:))
>
>>you could use scatter name, example:
>>
>>select table1
>>scatter loname1
>>select table2
>>scatter loname2
>>
>>?COMPOBJ(m.loname1,m.loname2)
>>
>>Should works?
>>
>>Franco

Gentlemen,
The following is what I used, it seems to have done the trick. Thank you all for your help. You guys are great.

select MyFirstTable
lnRecTotal = RECCOUNT()

FOR lnRecCount = 1 to lnRecTotal
	GO lnRecCount
	IF NOT deleted()
		SCATTER NAME loName1 
		SELECT MySecondTable
		SCATTER NAME loName2
		SCAN REST FOR COMPOBJ(loName1,loName2) = .T.
		  	
			if COMPOBJ(loName1,loName2) = .T.
				SELECT MyFirstTable
				GO lnRecCount
				DELETE
			ENDIF
			WAIT WINDOW STR(lnRecCount) nowait
			
		ENDSCAN 
	ENDIF 
ENDFOR