mysql query needed urgently -- 2

Job ID: 34673547

Budget: $10 – $30 USD

we have a list of films that need connecting to IDs
the we have the name of the film and the year in one table (A)
and the ID name year in table (B)
we need the ID to be in table (A)