>Have a group of rows - group1. Have a complete list of all rows - mastergroup. Want to delete from group1 any records that have no match in the mastergroup. Currently i am looping through group1 doing a seek on mastergroup Both group1 and mastergroup are indexed on the same index, and the index matches the seek. Still the mastergorup is large and the sql requires 30 seconds.
>
>any ideas on how i can make this more efficient?

I guess I would do it with just

SELECT GROUP1
SET RELATION TO thekey INTO MASTERGROUP
DELETE FOR !FOUND("MASTERGROUP")

-- or do you require doing it with SQL?