It doesn't like the reference to G in the subquery. This should do the job:

select G.cStyle, G.kGarment, G.cDescrip, G.nDefPrice ;
  from Garments G ;
  INNER JOIN LocGarment LG ON (LG.kGarment = G.kGarment) AND (LG.kLoc = lkLoc)

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