[OPEN-ILS-GENERAL] introduction and quick database question

[Jesse Ephraim]

I am the director of a library in a consortium of small libraries in the
Dallas-Fort Worth metroplex area of Texas.  We launched Evergreen a few
months ago.

 

I am working on some reports that go beyond the basic capabilities of
the built-in reporting tool in Evergreen, so I am pulling the data via
standard SQL queries.   I have one quick question: 

 

I don't see "title" and "author" information anywhere within any of the
ASSET tables (other than empty "dummy_title" and "dummy_author" fields
in asset_copy), so I looked to the METABIB table to pull that
information.  However, I am having trouble locating the common
identifier to tie the tables together when I JOIN them so I can link the
appropriate author and title information to the individual copies.  I
know I must be overlooking something obvious, but if someone could give
me a quick hint, I would really appreciate it!

 

Thanks!

 

Jesse Ephraim

 

Director, Roanoke Public Library

308 S. Walnut

Roanoke, Texas 76262

(817) 491-2691

jephraim at roanoketexas.com

 

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://libmail.georgialibraries.org/pipermail/open-ils-general/attachments/20091207/8977c59f/attachment.htm