shrug-l: ModelBuilder question

[Wolfe, Heather]

I am having trouble getting Model Builder to join something with a
one-to many relationship (a point to parcel spatial join output) to
something else with a one to one relationship( a selection of parcels).
In arc map, this would be a simple join, but it appears that the Toolbox
version does not have the capability to simply select the first one
(even though the literature says it does). If I could simply select the
duplicates, I could delete them, but I couldn't find a tool to do it.
Our programmer wrote an SQL query that would select them (see below),
but I can't find a tool that will accept an advanced SQL query. I would
be grateful for any ideas.

"FID" IN (SELECT MIN( "FID" ) FROM SPJoin2 GROUP BY "PARCELNUM")

Thanks,

Heather Wolfe
Sr. GIS Analyst, Planning & Development
Seminole County Government
1101 E. First St.
Sanford, FL 32771

Office 407-665-7378
Fax 407-665-7412
HWolfe at seminolecountyfl.gov
www.seminolecountyfl.gov



-----Original Message-----
From: shrug-l-bounces at lists.dep.state.fl.us
[mailto:shrug-l-bounces at lists.dep.state.fl.us] On Behalf Of
shrug-l-request at lists.dep.state.fl.us
Sent: Wednesday, April 25, 2007 12:00 PM
To: shrug-l at lists.dep.state.fl.us
Subject: SHRUG-L Digest, Vol 18, Issue 27

Send SHRUG-L mailing list submissions to
	shrug-l at lists.dep.state.fl.us

To subscribe or unsubscribe via the World Wide Web, visit
	http://lists.dep.state.fl.us/mailman/listinfo/shrug-l
or, via email, send a message with subject or body 'help' to
	shrug-l-request at lists.dep.state.fl.us

You can reach the person managing the list at
	shrug-l-owner at lists.dep.state.fl.us

When replying, please edit your Subject line so it is more specific than
"Re: Contents of SHRUG-L digest..."
 
-****Florida has a very broad Public Records Law. Virtually all written communications to or from State and Local Officials and employees are public records available to the public and media upon request. Seminole County policy does not differentiate between personal and business emails. E-mail sent on the County system will be considered public and will only be withheld from disclosure if deemed confidential pursuant to State Law.****-
 
-****Florida has a very broad Public Records Law. Virtually all written communications to or from State and Local Officials and employees are public records available to the public and media upon request. Seminole County policy does not differentiate between personal and business emails. E-mail sent on the County system will be considered public and will only be withheld from disclosure if deemed confidential pursuant to State Law.****-