Request SQL

[Thierry Nauze]

Le 25 mars 04, à 09:30, Mahesh Markus a écrit :

> try
> 	SELECT tblName.FieldA
> 	FROM 	tblName
> 	WHERE count( tblName.FieldB ) > 1
> 	GROUP BY tblName.FieldB
>
> If this doesn't work include FieldB in the select statement
>
> Good Luck
>
> Mahesh

Thank you but that does not work.

COUNT does not seem to work with WHERE but only with SELECT; o (


--
Thierry Nauze			Saint-Denis de la Réunion