Serviio

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.

there is a table GENRE_ITEM which links genre_id and media_item_id.

I have the basics proessays working fine, but cannot see how to join the media_item table to the genre table.

Hi,
You'll need to join the media table to the Media_Genre table and the genre table to the Media_Genre table.