i have just created a database and want to output the table to allow me to delete records . I have created the table using a join . I have created 3 tables one with actor with an id and name , the same for director and a cast table combining them together . I then created a join table to show the cast id with the name of director and actor .Now i want to create an update statment based on this to update the director/ actor id(cast table) columns when the user enters a known actor/director name.
SELECT Cast.Cast_Id, Director.Director_name, Actor.Actor_name FROM Cast INNER JOIN Actor ON Cast.Actor_Id = Actor.Actor_Id INNER JOIN Director ON Cast.Director_Id = Director.Director_Id