Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: easy question

Re: easy question

From: <joe_celko_at_my-deja.com>
Date: 2000/04/01
Message-ID: <8c51uk$j99$1@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 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US