[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