﻿Select	
	Actor.firstname		As FNActor,
	Movie.movtitle		As MVTitle,
	ActorMovie.role
    From 
	Actor
	    Inner Join 
	ActorMovie
	    on	Actor.ActorID 	    =   ActorMovie.ActorID 
	    Inner Join
	Movie
	    on	Movie.MovID    	    =   ActorMovie.MovID

