🚀 go-pugleaf

Hi!

My problem essentially is using multiple expressions in the select
statement. An example is given below:

SELECT c.club, count(customer_n) / 19 *0.175  * 10000 AS total
FROM customer AS x, club AS c
WHERE x.church_id = c.club_id
GROUP BY c.club;

I am writing some software in Visual dBase 5.5 pro and a query along the
same line as the one above is the only part of the program (other than
generating some reports of it) left. The error that is returned is that this
is not 'supported'. Essentially my question is whether or not the new
version dBase 7 supports an sql statement like this ?

NB. Have tested this sql statement out in Access 97 and it works fine. Am
wondering also if dBase v7 offers the same sort of support for sql as Access
does ?