Natural join in SQL Server

by

No, and thank the lucky stars

I can’t believe that you’d want the engine to guess the JOIN for you

Related links:

Edit, to explain why

  • The JOIN (whether USING or ON) is clear and explicit
  • I should be able to name my columns for the entity stored in the table, without worrying about what a column is called in another table, without NATURAL JOIN side effects

Quoting Bill Karwin in this excellent answer:

I never use NATURAL JOIN because I don’t like the possibility that the
join could do something I don’t intend just because some column name
exists in both tables.

More Related Contents:

  1. How to display data in JOIN, and return null value? [closed]
  2. SQL update from one Table to another based on a ID match
  3. Can I use CASE statement in a JOIN condition?
  4. Difference between JOIN and INNER JOIN
  5. Difference between left join and right join in SQL Server [duplicate]
  6. Implement paging (skip / take) functionality with this query
  7. Joining multiple tables in SQL
  8. SQL Inner Join On Null Values
  9. Removing duplicate rows (based on values from multiple columns) from SQL table
  10. SQL QUERY COUNT THEN ADD
  11. SQL server command help and tutorials for specific commands?
  12. How do I UPDATE from a SELECT in SQL Server?
  13. Referring to a Column Alias in a WHERE Clause
  14. Function vs. Stored Procedure in SQL Server
  15. What are Covering Indexes and Covered Queries in SQL Server?
  16. What’s the best way to select the minimum value from several columns?
  17. Add a summary row with totals
  18. Counting DISTINCT over multiple columns
  19. Finding duplicate rows in SQL Server
  20. Detect consecutive dates ranges using SQL
  21. Why does SQL Server round off results of dividing two integers?
  22. How to Map Input and Output Columns dynamically in SSIS?
  23. Find the real column name of an alias used in a view?
  24. Venn Diagram for Natural Join
  25. SQL Server: should I use information_schema tables over sys tables?
  26. How to create a pivot query in sql server without aggregate function
  27. IN vs. JOIN with large rowsets
  28. SQL Server Cumulative Sum by Group
  29. SQL Server FOR XML Path make repeating nodes
  30. What’s the correct name for an “association table” (a many-to-many relationship) [closed]

Leave a Comment