THE GEIGER DATABASE


GEIGER QUERY PROCEDURES
Database JGDBFULL Query Set

PROCEDURE 98: LGBOOKLIBCODE1CODE2 (sic)

The query returns a list of books in the Geiger library with a Dewey Decimal system classification of 720 to 720.99.

Note: The column labels shown within the query structures are historical references only, and do not reflect the definitions used within the version of the database being served through the website.

PROCEDURE NOTES

Procedure LGBOOKLIBCODE1CODE2 calls on Table MMJGBKLB with a filter applied on Column [CODE] to include only rows with a value of 720 to 720.99 whose value on Column [RETAIL] is not blank. The report format produced a list alphabetical by author, editor, and title, grouped with count totals.

The query structure is the same as PROCEDURE 35: LGBOOKLIBCODE1CODE2 (sic) in Database JGDB10.

Database Search

Search based on this procedure can be executed through the version of the database available on the website.

  • Search Database

ORIGINAL DATAEASE PROCEDURE SCREENS

Query Structure

JGDBFULL Procedure 98 query image

Report Format

JGDBFULL Procedure 98 report image 

Document: Dataease Procedure Definition Printout (PDF)