A Basic OPAC!

We can retrieve all the data from our database and book table using a couple of different queries.

Query 1: Retrieving Publisher and Author Data

Publisher Penguin Books published a book by John Green.

Publisher Dutton published a book by John Green.

Publisher University of Chicago Press published a book by Valerie Curtis.

Publisher Chelsea Green Publishing published a book by Sandor Ellix Katz.

Publisher Little, Brown & Company published a book by J. D. Salinger.

Publisher W. W. Norton & Company published a book by Homer (translated by Emily Wilson).

Publisher Scholastic published a book by K. A. Applegate.

Query 2: Retrieving Author, Title, and Date Published Data

A book by John Green titled Looking For Alaska was released in 2005-01-01.

A book by John Green titled Turtles All the Way Down was released in 2017-10-10.

A book by Valerie Curtis titled Don't Look, Don't Touch, Don't Eat was released in 2013-01-01.

A book by Sandor Ellix Katz titled The Art of Fermentation was released in 2012-01-01.

A book by J. D. Salinger titled The Catcher in the Rye was released in 1951-07-16.

A book by Homer (translated by Emily Wilson) titled The Iliad was released in 2023-09-26.

A book by K. A. Applegate titled The Invasion was released in 1996-06-01.

A book by K. A. Applegate titled The Visitor was released in 1996-06-01.

A book by K. A. Applegate titled The Encounter was released in 1996-08-01.

A book by K. A. Applegate titled The Message was released in 1996-10-01.

A book by K. A. Applegate titled The Predator was released in 1996-12-01.

A book by K. A. Applegate titled The Capture was released in 1997-02-01.

A book by K. A. Applegate titled The Stranger was released in 1997-04-01.

A book by K. A. Applegate titled The Alien was released in 1997-07-01.

A book by K. A. Applegate titled The Secret was released in 1997-08-01.

A book by K. A. Applegate titled The Android was released in 1997-08-01.

A book by K. A. Applegate titled The Forgotten was released in 1997-09-01.

A book by K. A. Applegate titled The Reaction was released in 1997-10-01.

A book by K. A. Applegate titled The Change was released in 1997-11-01.

A book by K. A. Applegate titled The Unknown was released in 1998-01-01.

A book by K. A. Applegate titled The Escape was released in 1998-01-01.

A book by K. A. Applegate titled The Warning was released in 1998-03-01.

A book by K. A. Applegate titled The Underground was released in 1998-04-01.

A book by K. A. Applegate titled The Decision was released in 1998-05-01.

A book by K. A. Applegate titled The Departure was released in 1998-07-01.

A book by K. A. Applegate titled The Discovery was released in 1998-08-01.

A book by K. A. Applegate titled The Threat was released in 1998-09-01.

A book by K. A. Applegate titled The Solution was released in 1998-10-01.

A book by K. A. Applegate titled The Pretender was released in 1998-11-01.

A book by K. A. Applegate titled The Suspicion was released in 1998-12-01.

A book by K. A. Applegate titled The Extreme was released in 1999-01-01.

A book by K. A. Applegate titled The Attack was released in 1999-02-01.

A book by K. A. Applegate titled The Exposed was released in 1999-03-01.

A book by K. A. Applegate titled The Experiment was released in 1999-04-01.

A book by K. A. Applegate titled The Sickness was released in 1999-05-01.

A book by K. A. Applegate titled The Reunion was released in 1999-06-01.

A book by K. A. Applegate titled The Conspiracy was released in 1999-07-01.

A book by K. A. Applegate titled The Separation was released in 1999-08-01.

A book by K. A. Applegate titled The Illusion was released in 1999-09-01.

A book by K. A. Applegate titled The Prophecy was released in 1999-10-01.

A book by K. A. Applegate titled The Proposal was released in 1999-11-01.

A book by K. A. Applegate titled The Mutation was released in 1999-12-01.

A book by K. A. Applegate titled The Weakness was released in 2000-01-01.

A book by K. A. Applegate titled The Arrival was released in 2000-02-01.

A book by K. A. Applegate titled The Hidden was released in 2000-03-01.

A book by K. A. Applegate titled The Other was released in 2000-04-01.

A book by K. A. Applegate titled The Familiar was released in 2000-04-01.

A book by K. A. Applegate titled The Journey was released in 2000-06-01.

A book by K. A. Applegate titled The Test was released in 2000-07-01.

A book by K. A. Applegate titled The Unexpected was released in 2000-08-01.

A book by K. A. Applegate titled The Revelation was released in 2000-09-01.

A book by K. A. Applegate titled The Deception was released in 2000-10-01.

A book by K. A. Applegate titled The Resistance was released in 2000-11-01.

A book by K. A. Applegate titled The Return was released in 2000-12-01.

A book by K. A. Applegate titled The Diversion was released in 2001-01-01.

A book by K. A. Applegate titled The Ultimate was released in 2001-02-01.

A book by K. A. Applegate titled The Absolute was released in 2001-03-01.

A book by K. A. Applegate titled The Sacrifice was released in 2001-04-01.

A book by K. A. Applegate titled The Answer was released in 2001-05-01.

A book by K. A. Applegate titled The Beginning was released in 2001-05-01.