SELECT movies.movie_Id, movies.title, movies.image, Movie_Directors.DirectorName
FROM movies INNER JOIN
Movie_Directors ON movies.movie_Id = Movie_Directors.movie_Id CROSS
WHERE (movies.title = "" or movies.title LIKE '%' + @title + '%') and (movies.actor= "" or movies.actor LIKE '%' + @actor+ '%')and (Movie_Directors.DirectorName= "" or Movie_Directors.DirectorName LIKE '%' + @DirectorName+ '%')
Group by DirectorName