I have two tables with date and id fields. I want to join on both fields. I tried 

JOIN t2 ON CONCAT(t1.id, t1.date)=CONCAT(t2.id, t2.date)

that works, but it is very slow. is there a better way to do this?

mysql join
Edit
Report