title: How to insert data to a table that is connected to a "middletable" which keeps track of two tables?
body: <p>Basically i need to add songs to a playlist, where the playlist needs to keep track of the consisting songs.</p>
  <p>my tables:</p>
  <pre><code>CREATE TABLE IF NOT EXISTS Playlist (
      id INTEGER PRIMARY KEY AUTOINCREMENT,
      title TEXT,
      image BLOB,
      private NUMERIC,
      playlistOwner INTEGER,
      FOREIGN KEY(playlistOwner) REFERENCES User(id)
  )
  
  CREATE TABLE IF NOT EXISTS Song (
      id INTEGER PRIMARY KEY AUTOINCREMENT,
      title TEXT,
      artistName VARCHAR(26),
      genre TEXT, 
      releaseDate DATE
  )
  
  CREATE TABLE IF NOT EXISTS SongsInPlaylist (
      playlistId INTEGER,
      songId INTEGER,
      FOREIGN KEY(playlistId) REFERENCES Playlist(id),
      FOREIGN KEY(songId) REFERENCES Song(id)
  )
  </code></pre>
  <p>I've tried to join the songsInPlaylist table with the song table when inserting data into the Song table but i'm not succeding. I wonder what the easiest solution would be to be able to read the songs in a specific playlist when requesting for the resource. any help is appreciated.</p>