Re: easy question

From: <joe_celko_at_my-deja.com>
Date: 2000/04/01
Message-ID: <8c51uk$j99$1_at_nnrp1.deja.com>#1/1


>> WHAT I REALLY WANT TO DO is query the database to find out which
people have read the book entitled MySQL. <<

You are in trouble. You need a table that shows the relationship between people and the books they checked out of the library. ALL relationaships in SQL are shown by values in the columns of tables -- they do not appear by magic.

SELECT name, title
  FROM Checkout
 WHERE name = 'Fred'
   AND title = 'MySQL';

--CELKO-- Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sat Apr 01 2000 - 00:00:00 CEST

Original text of this message