joshua.vw
Reputation: 67
Is CROSS JOIN the same as INNER JOIN / JOIN with out the ON condition?
Why would you use the CROSS JOIN keyword if you can just do INNER JOIN and have no condition? Am I missing something? Also can cross joins have on conditions?
Upvotes: 0
Views: 1120
Answers (1)
Akina
Reputation: 42844
In MySQL,
JOIN,CROSS JOIN, andINNER JOINare syntactic equivalents (they can replace each other).In standard SQL, they are not equivalent.
INNER JOINis used with anONclause,CROSS JOINis used otherwise.
MySQL Reference Manual / ... / JOIN Clause
Upvotes: 1
Related Questions
- MySQL - JOIN without ON clause vs CROSS JOIN vs SELECT t1.* t2.* FROM t1, t2;
- INNER JOIN ON vs WHERE clause
- What is the difference between writing sql join on together and separately?
- In SQL / MySQL, what is the difference between "ON" and "WHERE" in a join statement?
- Difference between inner join query with a inner join..on and where clause query?
- In SQL, what's the difference between JOIN and CROSS JOIN?
- Is CROSS JOIN a synonym for INNER JOIN without ON clause?
- Comparing MySQL Cross and Inner Joins
- MySQL JOIN statement cross join?
- MySQL "ON" condition - What does it do?