Query bellow fine working under sql server 2005 but under foxpro 9 I have error message:
"Queries of this type are not supported"
Ist the way to solve this problem ?


"SELECT kontrah.kont_skr,;
( select top 1 faktury.fakt_bru FROM faktury WHERE faktury.kont_hex = kontrah.kont_hex ORDER BY faktury.fakt_bru desc) AS OBROT;
FROM kontrah;
WHERE kontrah.kont_hex > 0"

Best regards