Game Item Database

[asdfen]

Hello all this is my first post.

I am making an item database with the goal of copying an online game database as displayed in link below:

http://www.shardsofdalaya.com/fomelo/fomelo.php?char=svettoy

I have created an item database

Items with joining databases that contain many to many relationships between item type and character type.

I am now in the process of making an individual character database and am stuck. What I am trying to do is limit items displayed from a value list of items to only usable in that inventory slot by this type of character. The problem I am having is that I am now dealing with joining files which do not provide me with the information I want.

The structure looks something like this:

databases:

character

item

character race

character class

item slots

joining files:

item_race

item_class

item_slot

now I need to look up for a particular slot in character database an item that fits a list of criteria such as slot/class/race/level etc

so far I can not think of a way to do it. Any tips