Mysql database merge
Posted by:
crosswire
(142.47.248.---)
Date: November 28, 2006 06:06PM
I have a books database. Now i have in one table called books the title,shelf,etc. Also i have another table called bookauthors - title,authorslastname, authorID(numneric).
The problem is that i want to have the authorlastname in table books.I dont want a seperate table.I dont want users to go into the bookauthors to look for author when i can make it all in one table called books. The reason i ended up like this was because i converted the library access database originally into mysql and thats what i ended up with.Because of the authorId, having multiple authors for the books,i dont have a clue as to how to make it work.
Any advice?
thanks
I used appgini to create the program to search the database.