Linking the media_item table to the genre table
Hi, I'm trying to write some simple SQL queries to run within the Derby ij interpretter to do simple things like list all movies in the database. I have the basics working fine, but cannot see how to join the media_item table to the genre table. I understand that the database schema may change across releases and am OK with accepting that risk. This is just for me.
Any suggestions, gratefully received.
Any suggestions, gratefully received.