I am creating a movie database. Right now I have each movie set up as its own table. Inside each table there are fields for title, summary, rating and so on.
On one of my web pages, feeding off this database, I want to show the movie title, summary and rating for every movie in the database. Will this be possible since each movie is it's own table? Can I select all database tables in a query? Should I set up my database differently? Any help will be much appreciated. Thanks.