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   )

What have I done to offend it?

Bob