Hi,
I need some help with the update function in the SQL mode.
SELECT Film.Nummer, Film.Titel, Film.Köpt, Film.Genre, Producent.Regissör
FROM Producent INNER JOIN Film ON Producent.[Nummer] = Film.[Nummer]
In my database I have a movie called Underworld (Film.Titel = movie.titel) and I want to change Film.köpt(=Movie.Bought) from 2008 to 2009.
Any ideas on how I should do it? Totally clueless on this one