Gossamer Forum
Home : Products : DBMan SQL : Discussion :

merging records

Quote Reply
merging records

I have a database for electronic journal titles with full text. Many of the same titles are included in several collections, but with different date coverage, etc. I am hoping to merge these titles so that only one record shows up, with all the different date coverages included in this one record, instead of several records with the same title.

Let me show you an example. Take a look at: http://www.indiana.edu/~libej/new.html and do a search for "Science" and check the exact title search box. The search will retrieve six records. I am hoping to merge the six into one, so only one record of the title comes up, without losing the rest of the information. So people can pick and choose the most appropriate link to go.

Is this possible? If so, how?

Thanks a lot.
Jian Liu
Indiana University Libraries
Subject Author Views Date
Thread merging records jiliu 2632 Jan 11, 2002, 9:16 AM
Thread Re: [jiliu] merging records
604 2585 Jan 11, 2002, 5:53 PM
Thread Re: [TheStone] merging records
jiliu 2575 Jan 12, 2002, 12:40 PM
Post Re: [jiliu] merging records
604 2561 Jan 14, 2002, 11:08 AM