You can also use XML. See
Re: Sending a list from vfp Thread #
827267 Message #
829213>can i give sql command in vfp9 like sql server
>select * from table1 where field1 in (select field1 from table2)
>delete from table1 where field1 in (select field1 from table2)
--sb--