sarah1405241480 0 Report post Posted March 7, 2005 (edited) Hi,every one I'm a new patron in your site. This couse I'm having a graduation course and I'm going to do a library system. I want you to sugest some reasonable way to do the following : each book may have a writer,translator,person who calculates information,person who sharing the writer, person who do the covering book,or .......etc how can i return all of them to the book details if I wabt to put them in a table . I'm thinking about puting them in table but to be as an type: for example CREATE TYPE book_type UNDER book_write_type (writer VARCHAR, translator VARCHAR, ........................ ....................... ) what do you think do you have any sugestion please as soon as possible. thank you Please don't shout in the forums. using large colorful text is considered shouting. I edited it to a more reasonable size. Please read the TOS for more information. PM me if you still are unsure how to post here. vujsa Edited March 7, 2005 by vujsa (see edit history) Share this post Link to post Share on other sites
miCRoSCoPiC^eaRthLinG 0 Report post Posted March 8, 2005 how can i return all of them to the book details if I wabt to put them in a table .I'm thinking about puting them in table but to be as an type:for example CREATE TYPE book_type UNDER book_write_type(writer VARCHAR,translator VARCHAR,...............................................) Your objective isn't quite clear sarah. Could you be a little more elaborate about what you are trying to return, here ?? Whats the frontend you are using ? How do you intend to set it up, what development platform you are using other than the SQL backend ?? Don't think we can help you much unless you come up with a good brief about your project.Regards Share this post Link to post Share on other sites