Im trying to create a primary key and cannot because I have a few duplicate
entries. There should not be any so I am trying to find them. The key
consists of 2 fields(po,line), Im trying to run a query that will only
display the duplicates, this is what Im trying.
SELECT po,line from table where po = po AND line = line
how can I change this so it only display's the duplicate entries?
-Adrian
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
