MySQL: Inner join vs Where [duplicate]

by

As pulled from the accepted answer in question 44917:

Performance wise, they are exactly the
same (at least in SQL Server) but be
aware that they are deprecating the
implicit outer join syntax.

In MySql the results are the same.

I would personally stick with joining tables explicitly… that is the “socialy acceptable” way of doing it.

More Related Contents:

  1. Recreating a query using INNER JOIN? [duplicate]
  2. What’s the difference between INNER JOIN, LEFT JOIN, RIGHT JOIN and FULL JOIN? [duplicate]
  3. MYSQL OR vs IN performance
  4. How to join two tables mysql?
  5. SQL Performance UNION vs OR
  6. Mixing ANSI 1992 JOINs and COMMAs in a query
  7. MySQL “IN” operator performance on (large?) number of values
  8. What is better in MYSQL count(*) or count(1)?
  9. Does Order of Fields of Multi-Column Index in MySQL Matter
  10. MySQL INNER JOIN select only one row from second table
  11. In SQL Server how to get the count of child if both parent and child are available [closed]
  12. Delete the entire content of all table in a Database [closed]
  13. MyISAM versus InnoDB [closed]
  14. Get a list of dates between two dates
  15. Calculate a running total in MySQL
  16. What’s faster, SELECT DISTINCT or GROUP BY in MySQL?
  17. How to use mysql JOIN without ON condition?
  18. Use MySQL spatial extensions to select points inside circle
  19. INSERT … ON DUPLICATE KEY (do nothing)
  20. MySQL create stored procedure syntax with delimiter
  21. Mysql Convert Column to row (Pivot table )
  22. Merge two tables in one SQL query and make the date values unique
  23. How can I speed up a MySQL query with a large offset in the LIMIT clause?
  24. How to find non-existing data from another Table by JOIN?
  25. MySQL/SQL: Update with correlated subquery from the updated table itself
  26. Greatest value of multiple columns with column name?
  27. What are practical differences between `REPLACE` and `INSERT … ON DUPLICATE KEY UPDATE` in MySQL?
  28. Execute INSERT if table is empty?
  29. Mysql How do you create a clustered index?
  30. How do I extract Month and Year in a MySQL date and compare them?

Leave a Comment