I'm learning mysql. Under all cases, is Join the same as Cross Join? For example, this query
SELECT * FROM table t1
JOIN table t2
Will always be the same as
SELECT * FROM table t1
CROSS JOIN table t2
Even if I add WHERE, GROUP BY, HAVING, LIMIT, ORDER etc.... conditions afterwards, JOIN and CROSS JOIN will always yield the same results?
Thanks