[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[ale] any SQL gurus?
- Subject: [ale] any SQL gurus?
- From: phasefx at magusaptus.com (Jason Etheridge)
- Date: Wed Jan 21 10:26:58 2004
Hi guys, this has been driving me nuts and maybe you would enjoy
figuring it out. :)
I have two tables: TITLE and COPY. There is a one-to-many relationship
between the two; for any given title, there could be many copies.
Copies have owners, but titles don't belong to anyone.
field title_key PRIMARY KEY
field name CHAR
field copy_key PRIMARY KEY
field title_key FOREIGN KEY
field owner CHAR
However, owners would like a list of what titles they happen to have
copies for. I can do this through brute-force with a programming
language, but is there a single SQL query I could use? Specifically,
MySQL (I don't have sub-selects)?
I'm sure this is simple and obvious and I'll feel like more of an idiot