MySQL how to join tables on two fields

Question

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

User · Accepted Answer

JOIN t2 ON t1 id t2 id AND t1 date t2 date

User · Answer

JOIN t2 ON  t2 id   t1 id AND t2 date   t1 date

User · Answer

JOIN t2 ON  t2 id   t1 id AND t2 date   t1 date

User · Answer

JOIN t2 ON  t2 id   t1 id AND t2 date   t1 date

User · Answer

SELECT    FROM t1 JOIN t2 USING  id  date    perhaps you ll need to use INNEER JOIN or where t2 id is not null if you want results only matching both conditions

User · Answer

SELECT    FROM t1 JOIN t2 USING  id  date    perhaps you ll need to use INNEER JOIN or where t2 id is not null if you want results only matching both conditions

User · Answer

JOIN t2 ON  t2 id   t1 id AND t2 date   t1 date

[mysql] MySQL how to join tables on two fields

Examples related to mysql

Examples related to join