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 2637 Jan 11, 2002, 9:16 AM
Thread Re: [jiliu] merging records
604 2589 Jan 11, 2002, 5:53 PM
Thread Re: [TheStone] merging records
jiliu 2579 Jan 12, 2002, 12:40 PM
Post Re: [jiliu] merging records
604 2565 Jan 14, 2002, 11:08 AM