I have some question based on this :
1)Do you want only records from Table1, which have no repetitive container like 'A01002'
2)The select query doesn't contain Table2, so what exact query should be only table1

If you want non repetitive container from table1 then use below query
select count(Container ), Container from table 1
group by Container
having count(Container ) = 1

Do reply on the above 2 points and whether this will suffix your problem.