SQL Query: Join Tables using two partial string matches
Not ultra familiar with Access, but I'm pretty sure you have LEFT and RIGHT functions available to you.  Something like this seems likely to work:

    ON  RIGHT( Table2.[Booking], 9 ) = RIGHT( Table1.[Booking], 9 )
    AND LEFT( Table2.[Container], 10 ) = LEFT( Table1.[Container], 10 );