> I have one sql command like this (in vfp 3.0): > SELECT number, sum(quantity), sum(value) from a > where a.month = m.month and b.year = m.year ; > group by number into CURSOR ccursor > I am going crazy, anyone could help me?? Post your SQL command exactly as it is. For now, check the "b.year =". You don't have any b table in the FROM clause. If you put the SQL in a method you have to be sure that m.year and m.month are not out of scope. Also you you might consider replacing "group by number" with "group by a.number".