How to choose from 2 tables? MySQL?

Question

MySQL

Good day to all, how to choose a name from 2 tables and, by its box number, select the number of its bananas for a specified date from 1 table?

Answer 1

Can be done with a subquery

select t2.name, 
(SELECT sum(bananas) from t1 WHERE t1.id=t2.id and t1.date = '2016.07.02') 
FROM t2 WHERE name = 'Denis'