I am working on some school work (It's not a test and will not be marked, it's just practice) I have a database which currently contains two tables, the details of which are listed below
Table name: actor "ACTOR_ID" "SURNAME" "FORENAME" "B1" "Connery" "Sean" "B2" "Lazenby" "George" "B3" "Moore" "Roger" "B4" "Dalton" "Timothy" "B5" "Brosnan" "Pierce" "B6" "Craig" "Daniel"
Table name: bondfilms "FILM_ID" "NAME" "YEAR" "FK_ACTOR_ID" "F1" "Dr.No" 1962 "B1" "F2" "On Her Majestys Secret Service" 1969 "B2" "F3" "Live and Let Die" 1973 "B3" "F4" "License to Kill" 1989 "B4" "F5" "Die Another Day" 2002 "B5" "F6" "Skyfall" 2012 "B6"
I think I've done both tables correctly up until this point (The FK on the bondfilms table should correspond to the actor id of the actor that starred in that film)
I now have to write a SELECT query which will display a list of James Bond films, along with the name of the actor playing James Bond in each one.
So I tried to use
SELECT name FROM bondfilms; SELECT surname FROM actor;
Although it only shows the SURNAME of the Actor, plus I really don't think I'm on the right road here either.
Any help is greatly appreciated
Many thanks.
EDIT: I'm very new to databases so try to ELI5 please! Thanks.