VFP doesn't like the following, and chokes on the subselect with the error message: "SQL: Queries of this type are not supported."
select G.cStyle, G.kGarment, G.cDescrip, G.nDefPrice ;
from Garments G ;
where lkLoc in (select LG.kLoc from LocGarment LG ;
where LG.kGarment = G.kGarment )