Linking tables in my book database!

Hi, i have a book database with following tables:

subject > sub_subject > sub_sub_subject > book

Finally i have a table called "book2subject", which is used to link or relate with the right subjects > book.

I cant' figure out how to link tables nor relate them to one anothor, so can i give you access to my Joomla backend, so yo can set it up for me please!

Best regards Hans

admin.heartslovefree wrote: Hi, i have a book database with following tables:
subject > sub_subject > sub_sub_subject > book

Finally i have a table called "book2subject", which is used to link or relate with the right subjects > book.

I am not sure that I understood what you want to do.
I guess subject is a kind of a category. Your categories are hierarchical? Like this!
Books>Cooking>Seefood

Some questions:

• Why do you have so many tables?
• Does a book has only one subject and one sub_subject ...?

Normally you do such stuff with nested tables. Take a look at the Joomla Categories Table.
mikehillyer.com/articles/managing-hierarchical-data-in-mysql/

If you just want to assign your table to one subject,sub_subject or sub_sub_subject you can insert 3 integer fields in your book-table and assign the table n:1 to your database adding subtemplates. JooDB will do the rest.

books:id_subject<=>subject::id
books:id_subject2<=>sub_subject::id
books:id_subject3<=>sub_sub_subject::id