> From: Code for Libraries [mailto:[log in to unmask]] On > Behalf Of Ben Ostrowsky > Sent: 23 May, 2006 11:06 > To: [log in to unmask] > Subject: Re: [CODE4LIB] Musings on using xISBN in our Horizon catalog > > > 2. lookup the FRBR key in the FRBR to ISBN relationship table > > Is there an OCLC query I could do, or do you mean that I > would create a table like this for our use? > In step (1) you locally created a FRBR key based upon the OCLC FRBR algorithm. Use that key as a search into the FRBR table in your database with a join to the ISBN table. That's what I meant by "lookup". For example, if you had the following database structure: tblFRBR pkFRBR, primary key, auto number txtFRBR, nvarchar tblISBN fkFRBR, foreign key to pkFRBR in tblFRBR txtISBN, nvarchar 1. Generate the FRBR key value 2. Lookup with SQL: SELECT tblFRBR.* FROM tblFRBR WHERE tblFRBR.pkFRBR = [argFRBR]; Where the value of [argFRBR] is the key value generated in step 1. Andy.