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
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