I am making a database for a project for school. I need to make a website with movie trailers on it.
I have made two tables, one is called Movie, the other one is called category.
In the Trailer table I have made these fields:
-cat_ID(which is linked to a field in the other table)
In the category table I have these fields:
-category(Name of the category)
Now I have made a link with both cat_ID fields. Now I want to be able to see category(the fields only in the category table) when I use the SQL query.
Does anyone know how to do this?
Thnx for your help!
P.S. Sorry for my bad English, I'm dutch