• The CSA Newsletter
• Technology Information
• The CSA Propylaea Project.
• The Older Propylon Project. This is a concluded research project of CSA Director Harrison Eiteljorg, II. The results of this project have been published; archival materials, including CAD models, may be accessed through the Archaeological Research Institute at Arizona State University.
• Lantern Slides of Classical Antiquity
• Pompeii Forum Project CSA participates in this on-going project, Directed by Prof. John J. Dobbins (University of Virginia), to study the Forum of ancient Pompeii. A computer-aided design model is being constructed of the forum.
• Bryn Mawr Electronic Resources Review (BMERR). BMERR was an online journal for reviews of electronic resources concerning the ancient world. Bryn Mawr Classical Review (BMCR) is now publishing reviews of electronic resources, and BMERR has discontinued its separate existence. Reviews published 1998-2000 are now available through the BMCR web site (http://bmcr.brynmawr.edu/) and they are available via the BMERR page there.
This page is intended to augment discussion in Archaeological Computing about table joins and SQL statements. It assumes that you have read the sections about table joins and select statements in the book.
These tables and the data organization described in Archaeological Computing will be used for this discussion:
Consider these joins plus SQL statements (as expressed in English):
Sample 1: Produce a list of the references linked to objects in the exhibition.
Sample 2: Select those Moche periods for which there are both exhibit objects and specified comparanda.
Sample 3: Produce a list of references used to refer to or illustrate comparanda.
Sample 4: Provide a list of all objects in the exhibit that have no comparanda.