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