Why can't use SQL "GROUP BY..."?

[Gary Fung]

Hi,

  I have a Perl program using DBI. I don't know why it will cause error when I use 
"GROUP BY..." in SQL "SELECT" statements.

My coding is similar as:

 $value2 = $dbh->prepare("SELECT page FROM $Table 

GROUP BY page") || die "Couldn't add record, ".$dbh->errstr();

Whenever I use "GROUP BY.." , an error statement will go out :

"SQL ERROR: Can't find table names in FROM clause!"

Can anyboby give help to me? 

Thank You very much!!

Regards,

Gary

Lonely Christmas(������)�A����P��(Twins)�A�L���D(�q�v)...
��In����a�n ���A�L�V��