[thelist] sql/table design question
Tom Dell'Aringa
pixelmech at yahoo.com
Tue Feb 18 09:24:01 CST 2003
Heyo,
I have a table that lists a bunch of books. Parts of these books are
reprinted in other books, which are in the same table. For example:
Book#1 (parts reprinted in Book#34 and Book#47)
So when I list out all the specs for book#1, I want to reference the
two other books as well, and create a link to them should the person
want to find out the information on those as well.
Is this going to create a problem for me with my select statements?
Here is my table layout:
bookID
bookTitle
bookNotes
bookRelatedTo (here is where I would list the bookIDs that match)
Tom
=====
var me = tom.pixelmech.webDeveloper();
http://www.pixelmech.com/
http://www.maccaws.com/
[Making A Commercial Case for Adopting Web Standards]
__________________________________________________
Do you Yahoo!?
Yahoo! Shopping - Send Flowers for Valentine's Day
http://shopping.yahoo.com
More information about the thelist
mailing list