"Jesse Sheidlower" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, February 24, 2003 8:09 PM
Subject: Select based on related date
>
> I'm having trouble with a query that I thought would be pretty
> straightforward. To simplify, I have a databa
I'm having trouble with a query that I thought would be pretty
straightforward. To simplify, I have a database of books that
has, say, two tables:
CREATE TABLE book (
id INT,
date_purch DATE
)
CREATE TABLE subj (
book_id INT,
subj TEXT
)
Each book can h
