在MySQL中连接两个表的方法有以下几种:
SELECT * FROM table1 INNER JOIN table2 ON table1.id = table2.id;
SELECT * FROM table1 LEFT JOIN table2 ON table1.id = table2.id;
SELECT * FROM table1 RIGHT JOIN table2 ON table1.id = table2.id;
SELECT * FROM table1 FULL JOIN table2 ON table1.id = table2.id;
SELECT * FROM table1 CROSS JOIN table2;
以上是常见的连接两个表的方法,根据实际需求选择合适的连接方式。