Problem with count()

[spwaste]

Hi, all. I run the following commands in MySQL:

create table a (a int);

create table b (b int);

select count(*)
from a, b;

select count(a.a)
from a, b;

select count(a.*)
from a, b;

The last statement results in a syntax error, but not the previous two. What's wrong? Count() takes one attribute or all, is it?