Select m.MovieID,m.Title,d.DirectorName,m.Actor1,m.Actor2,g.GenreName
from  
            Movies m 
inner Join  Directors d
on          m.DirectorID = d.DirectorID
Inner Join  Genres g
on          m.GenreId = g.GenreID
      

--A update statement needs to be ran against a individual table

Update m
set m.DirectorID    = D.DirectorID
from 
           Movies m 
Cross join       Direcectors  d
where 
      m.Title =  'Jaws'
and   d.DirectorName = 'Steven Spielburg'
 
--Notice the join I used was a Cross Join and not a Inner Join This allowed me to referance every 
--director ID for Spielburg.  Please keep in mind this is a example and if I was actualy trying to
--accomplish what I did above I would use a differant method.  But this should illustrate to you 
--how to join tables and update with joins.

SELECT m.mov_Title AS Title,
	m.mov_Length AS [Length in Minutes],
	m.mov_YrReleased AS [Year Released],
	g.gen_Genre AS Genre,
	d.dir_FName + d.dir_LName AS Director,
	a1.act_FName + a1.act_LName AS [Starring Actor],
	a2.act_FName + a2.act_LName AS [Co-Starring Actor],
	a3.act_FName + a3.act_LName AS [Supporting Actor],
	a4.act_FName + a4.act_LName AS [Supporting Actor]
FROM Movies AS m 
	INNER JOIN Genres AS g ON m.mov_GenreID = g.UID_Genres
	INNER JOIN Directors AS d ON m.mov_DirectorID = d.UID_Directors
	INNER JOIN Actors AS a1 ON m.mov_ActorID1 = a1.UID_Actors
	LEFT JOIN Actors AS a2 ON m.mov_ActorID2 = a2.UID_Actors
	LEFT JOIN Actors AS a3 ON m.mov_ActorID3 = a3.UID_Actors
	LEFT JOIN Actors AS a4 ON m.mov_ActorID4 = a4.UID_Actors

INSERT INTO Movies 
	(title,
	length,
	year,
	(get UID_Genres value from Genres table matching user-entered genre name & put that into mov_GenreID column in movies table),
	(get UID_Directors value from Directors table matching user-entered director name &
		put that into mov_DirectorID column in movies table),
	(get UID_Actors value from Actors table matching user-entered actor name &
		put that into mov_ActorID column in movies table
		(repeat this four times - once for each actor column in movies table))

VALUES (@title, @length, @year, @genre, @director, @actor1, @actor2, @actor3, @actor4)

INSERT INTO Movies
	(mov_Title,
	mov_Length,
	mov_YrReleased,
	(SELECT g.UID_Genres
		FROM Genres g
		WHERE g.gen_Genre = @genre),
	(SELECT d.UID_Directors
		FROM Directors d
		WHERE d.dir_LName = @director),
	(SELECT a.UID_Actors
		FROM Actors a
		WHERE a.act_LName = @actor1)
	(SELECT a.UID_Actors
		FROM Actors a
		WHERE a.act_LName = @actor2)
	(SELECT a.UID_Actors
		FROM Actors a
		WHERE a.act_LName = @actor3)
	(SELECT a.UID_Actors
		FROM Actors a
		WHERE a.act_LName = @actor4)
	INNER JOIN Genres AS g ON m.mov_GenreID = g.UID_Genres
	INNER JOIN Directors AS d ON m.mov_DirectorID = d.UID_Directors
	INNER JOIN Actors AS a1 ON m.mov_ActorID1 = a1.UID_Actors
	LEFT JOIN Actors AS a2 ON m.mov_ActorID2 = a2.UID_Actors
	LEFT JOIN Actors AS a3 ON m.mov_ActorID3 = a3.UID_Actors
	LEFT JOIN Actors AS a4 ON m.mov_ActorID4 = a4.UID_Actors
	--I pretty much did the joins based on my SELECT statement I have in an earlier post...
VALUES (@title, @length, @year, @genre, @director, @actor1, @actor2, @actor3, @actor4)

INSERT INTO Movies (mov_GenreID)
VALUES (SELECT uid_genre FROM genres WHERE gen_genre = 'Science Fiction')

DECLARE 
@title nvarchar(50),
@length int,
@year int,
@genre nvarchar(50),
@director nvarchar(50),
@actor1 nvarchar(50),
@actor2 nvarchar(50),
@actor3 nvarchar(50),
@actor4 nvarchar(50)

SET @title = 'War of the Worlds'
SET @length = 142
SET @year = 2005
SET @genre = 'Science Fiction'
SET @director = 'Spielberg'
SET @actor1 = 'Cruise'
SET @actor2 = ''
SET @actor3 = ''
SET @actor4 = ''

INSERT INTO Movies  (mov_Title, mov_Length, mov_YrReleased)
 VALUES  (@title, @length, @year)
INSERT INTO Movies (mov_GenreID)
	SELECT UID_Genres
	FROM Genres
	WHERE gen_Genre = @genre
INSERT INTO Movies (mov_DirectorID)
	SELECT UID_Directors
	FROM Directors
	WHERE dir_LName = @director
INSERT INTO Movies (mov_ActorID1)
SELECT UID_Actors FROM Actors WHERE act_LName = @actor1