THE GEIGER DATABASE
GEIGER QUERY PROCEDURES
DATABASE JGDB10 QUERY SET
PROCEDURE 137: JGFLLWBOOKSONLY
The query returns a list of books on 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 JGFLLWBOOKSONLY calls on Table MMJGBKLB with a filter applied on Columns [SUBJECT] ("=Wright, Frank Lloyd, 1867-1959") to select only books with that subject heading, [RETAIL] ("not = blank") to select only books with a valuation, and [SUBJECTID] ("Book") to select only books with that subject heading. The report format produced a block layout list showing bibliographic information, including numbers related to citations found in Frank Lloyd Wright: An Annotated Bibliography, by Robert L. Sweeney, and count of copies, ordered alphabetically by last name of author or editor. The last generation of the report contained 222 entries. The comment on the Report Format image below should be consulted.
The query structure is the same as PROCEDURE 134: JGFLLWBOOKS and similar to PROCEDURE 57: JGFLLWBOOKLIBRARY in Database JGDB10; and PROCEDURE 120: JGFLLWBOOKLIBRARY 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)