select * from mytable where field1 in (select field2 from mytable2 where field3 in (select field3 from mytable3 where field4 = 'Somevalue'))The first subquery has a where clause that also has a subquery. This is not allowed in VFP.
select * from org_code where; org_code in (select org_code from org_code where start_org = '1.2.2.0') or; org_code in (select org_code from org_code where start_org = '1.2.2.1') or; org_code in (select org_code from org_code where start_org = '1.2.2.2') or; org_code in (select org_code from org_code where start_org = '1.2.2.3') or; org_code in (select org_code from org_code where start_org = '1.2.2.4') or; org_code in (select org_code from org_code where start_org = '1.2.2.5') or; org_code in (select org_code from org_code where start_org = '1.2.2.6') or; org_code in (select org_code from org_code where start_org = '1.2.2.7') or; org_code in (select org_code from org_code where start_org = '1.2.2.8')This is not a very well thought out query but it demonstrates the limitation.