以下哪些语句在MySQL中是合法的？ A SELECT * FROM table1 LEFT JOIN table2 ON table1.id = table2.id; B SELECT * FROM table1 CROSS JOIN table2 ON table1.id = table2.id; C SELECT * FROM table1 JOIN table2 USING (column1); D SELECT * FROM table1 INNER JOIN table2 ON table1.id = table2.id; ACD