Request SQL

[Mahesh Markus]

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
-----Original Message-----
From: Thierry Nauze [mailto:huancaya at wanadoo.fr] 
Sent: Thursday, 25 March 2004 3:46
To: Valentina Developers
Subject: Request SQL


Hello,

In broad outline, I have a table with two fields

FieldA 	FieldB
a		A
b 		A
c 		B
d 		A
e 		C
f 		B

Which request SQL (SELECT ...), if it is possible, it is necessary to 
use to obtain a cursor containing only the records where the 
occurrences of FielsB are multiple:
a		A
b 		A
c 		B
d 		A
f 		B

Thank you beforehand

--
Thierry Nauze			Saint-Denis de la Réunion
_______________________________________________
Valentina mailing list
Valentina at lists.macserve.net http://lists.macserve.net/mailman/listinfo/valentina