Hey guys! im a bit lost in Sqlite..i just converted some stuff in my app from sharedpref to sql..


So i have a a table called Vod that store all my movies (name,icon,url..) . (from a json API)

when i update my list a created a temp table to store the new data downloaded (there is a button update or on load i check)

the goal is to compare both and only add to the Vod table the missing movies?

cause i also want to show the new movies...

Unless there is a way to update the table with only the new data and then find out what movies were added?

im a clear?lol cause in my head i think so...lol