FAQ  •  Register  •  Login

Linking the media_item table to the genre table

<<

martianw

Streaming enthusiast

Posts: 25

Joined: Fri Dec 14, 2012 2:49 pm

Post Sun Mar 15, 2020 8:21 am

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.
<<

zip

User avatar

Serviio developer / Site Admin

Posts: 17147

Joined: Sat Oct 24, 2009 12:24 pm

Location: London, UK

Post Tue Mar 17, 2020 9:05 am

Re: Linking the media_item table to the genre table

there is a table GENRE_ITEM which links genre_id and media_item_id.

Return to Third-party tools integration

Who is online

Users browsing this forum: No registered users and 1 guest

Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group.
Designed by ST Software for PTF.