Yes, both statements are valid in VFP.

>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)