Select *
from t1 inner join t2
on t1.id = t2.id
where t1.date = '2018-01-01' Select *
from t1 left join t2
on t1.id = t2.id
where t1.date = '2018-01-01'
and t2 is not null Select *
from t2 left join t1
on t1.id = t2.id
where t1.date = '2018-01-01'
and t1.id is not null!!! Комикс Сверхразум