THE GEIGER DATABASE


GEIGER QUERY PROCEDURES
Database JGDBFULL Query Set

PROCEDURE 97: JGBOOKLIBNOTFLLW720+

The query returns a list of books in the Geiger library not related to Frank Lloyd Wright within a range of Dewey Decimal system classifications.

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 JGBOOKLIBNOTFLLW720 calls on Table MMJGBKLB with filters applied on various columns to exclude Frank Lloyd Wright as a subject and two physical storage locations within the Geiger apartment, and include a range of Dewey Decimal system classifications between 720 and 760. The report format produced a list including an inventory number, author, and title, grouped and count subtotaled. The last generation of the report contained 296 entries.

The query structure is similar to PROCEDURE 34: JGBOOKLIBRARYNOTFLLW+ and PROCEDURE 171: BOOKSARCHNOTFLLW 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 97 query image

Report Format

JGDBFULL Procedure 97 report image 

Document: Dataease Procedure Definition Printout (PDF)