SQL Count(*)

[davy.cox]

I would like to make an SQL that counts the records resulting from an
other SQL:

This is the Query resulting the records (31 in my test)

SELECT A.customerid FROM A INNER JOIN customers ON A.customerid =
customers.Customerid WHERE Left([PeriodeID],8)='20070625' AND
customers.Companyid=97 GROUP BY A.customerid;
I would like just one record result with the total count of the
records in this query: 31
I tried things like:

SELECT Count(*) FROM (SELECT A.customerid FROM A INNER JOIN customers
ON A.customerid = customers.Customerid WHERE Left([PeriodeID],
8)='20070625' AND customers.Companyid=97 GROUP BY A.customerid;)

But he keeps on giving me an error on the FROM clause

Anyone who can help me, probably supper simple, but I gave up
searching and really can't find it.

Thanks in advance

[Yitzak]

On 10 Jul, 16:08, [e-mail] wrote:

I would like to make an SQL that counts the records resulting from an
other SQL:

This is the Query resulting the records (31 in my test)

SELECT A.customerid FROM A INNER JOIN customers ON A.customerid =
customers.Customerid WHERE Left([PeriodeID],8)='20070625' AND
customers.Companyid=97 GROUP BY A.customerid;

I would like just one record result with the total count of the
records in this query: 31
I tried things like:

SELECT Count(*) FROM (SELECT A.customerid FROM A INNER JOIN customers
ON A.customerid = customers.Customerid WHERE Left([PeriodeID],
8)='20070625' AND customers.Companyid=97 GROUP BY A.customerid;)

But he keeps on giving me an error on the FROM clause

Anyone who can help me, probably supper simple, but I gave up
searching and really can't find it.

Thanks in advance

Shouldn't the semi colon be the last item?

GROUP BY A.customerid;) ---GROUP BY A.customerid);

[Bob Quintal]

da******@gmail.com wrote in
news:11**********************@22g2000hsm.googlegro ups.com:

I would like to make an SQL that counts the records resulting
from an other SQL:

This is the Query resulting the records (31 in my test)

SELECT A.customerid FROM A INNER JOIN customers ON
A.customerid = customers.Customerid WHERE
Left([PeriodeID],8)='20070625' AND customers.Companyid=97
GROUP BY A.customerid;
I would like just one record result with the total count of
the records in this query: 31
I tried things like:

SELECT Count(*) FROM (SELECT A.customerid FROM A INNER JOIN
customers ON A.customerid = customers.Customerid WHERE
Left([PeriodeID], 8)='20070625' AND customers.Companyid=97
GROUP BY A.customerid;)

But he keeps on giving me an error on the FROM clause

Anyone who can help me, probably supper simple, but I gave up
searching and really can't find it.

Thanks in advance

SELECT count(A.customerid)
FROM A
INNER JOIN customers
ON A.customerid = customers.Customerid
WHERE Left([PeriodeID],8)='20070625'
AND
customers.Companyid=97;

--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com