They are functionally equivalent, but INNER JOIN
can be a bit clearer to read, especially if the query has other join types (i.e. LEFT
or RIGHT
or CROSS
) included in it.
More Related Contents:
- How to display data in JOIN, and return null value? [closed]
- What is the difference between “INNER JOIN” and “OUTER JOIN”?
- INNER JOIN ON vs WHERE clause
- SQL update from one Table to another based on a ID match
- Can I use CASE statement in a JOIN condition?
- How can I delete using INNER JOIN with SQL Server?
- SQL Inner-join with 3 tables?
- Difference between left join and right join in SQL Server [duplicate]
- Multiple INNER JOIN SQL ACCESS
- Is having an ‘OR’ in an INNER JOIN condition a bad idea?
- Implement paging (skip / take) functionality with this query
- WHERE Clause vs ON when using JOIN
- Natural join in SQL Server
- Is it true that using INNER JOIN after any OUTER JOIN will essentially invalidate the effects of OUTER JOIN?
- Eliminating duplicate values based on only one column of the table
- Joining multiple tables in SQL
- SQL Inner Join On Null Values
- INNER JOIN vs multiple table names in “FROM” [duplicate]
- Removing duplicate rows (based on values from multiple columns) from SQL table
- How can I convert bigint (UNIX timestamp) to datetime in SQL Server?
- SQL Server Insert if not exists
- How do you return the column names of a table?
- INT vs Unique-Identifier for ID field in database
- Why does this SQL code give error 1066 (Not unique table/alias: ‘user’)?
- SQL Server date format function
- The SQL OVER() clause – when and why is it useful?
- How to get export output in “real” CSV format in SQL Server Management Studio?
- Merge overlapping date intervals
- Script to save varbinary data to disk
- How to find out what is locking my tables?