MySQL how to join tables on two fields December 19, 2022 by Tarik JOIN t2 ON t1.id=t2.id AND t1.date=t2.date