Here's the SQL:
select course_id from tablename where staff_id = 'staff_id_value' group by course_id having count(course_id) > 1;
(Sorry, I'm not sure how that would look in a search action.)
- Jeff
--Looking for an easy way to bring back a list of duplicate course ID's for a given staff_ID in a table based on a search action along if possible
SQL 2000 -- Dan Stein Digital Software Solutions 799 Evergreen Circle Telford PA 18969 Land: 215-799-0192 Mobile: 610-256-2843 Fax 413-410-9682 FMP, WiTango, EDI,SQL 2000 [EMAIL PROTECTED] www.dss-db.com
Jeffrey Bohmer VisionLink, Inc. _________________________________ 303.402.0170 www.visionlink.org _________________________________ People. Tools. Change. Community. ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
