THE GEIGER DATABASE
GEIGER QUERY PROCEDURES
DATABASE JGDB10 QUERY SET
PROCEDURE 172: BOOKARTNOTFLLW
The query returns a list of art history books not related to Frank Lloyd Wright found in the library of John Geiger.
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 BOOKARTNOTFLLW calls on Table MMJGBKLB with filters applied to Columns [SUBJECTID] ("Book") to select only rows with that value, [SUBJECT] ("not = Wright, Frank Lloyd, 1867-1959) to select rows without that value, and [CODE] ("= between '700*' to '719*'", and "'721' to '749*'") to include only rows with values in that range of the Dewey Decimal classification system. The report format produced a block layout list showing bibliographic information. The last generation of the report contained 28 entries. The comment in the Report Format image below describes the purpose of this procedure. This procedure did not execute in the last version of the database, but may have a first draft for the search designed in PROCEDURE 173: BOOKSNOTARCH/ARTFLLW in Database JGDB10.
The query is similar to PROCEDURE 35: LGBOOKLIBCODE1CODE2 in Database JGDB10, and PROCEDURE 98: LGBOOKLIBCODE1CODE2 in Database JGDBFULL.
Database Search
Search based on this procedure cannot be executed through the version of the database available on the website.
ORIGINAL DATAEASE PROCEDURE SCREENS
Query Structure
Report Format
Document: Dataease Procedure Definition Printout (PDF)