How do I decide when to use right joins/left joins or inner joins Or how to determine which table is on which side?

by

Yes, it depends on the situation you are in.

Why use SQL JOIN?

Answer: Use the SQL JOIN whenever multiple tables must be accessed through an SQL SELECT statement and no results should be returned if there is not a match between the JOINed tables.

Reading this original article on The Code Project will help you a lot: Visual Representation of SQL Joins.

alt text

Also check this post: SQL SERVER – Better Performance – LEFT JOIN or NOT IN?.

Find original one at: Difference between JOIN and OUTER JOIN in MySQL.

More Related Contents:

  1. SQL: Repeat a result row multiple times, and number the rows
  2. Why in SQL NULL can’t match with NULL?
  3. SQL Query needed for fetch value from Two identical table but not fully identical table
  4. sql query to modify the selected value from database [closed]
  5. In SQL Server how to get the count of child if both parent and child are available [closed]
  6. Calculate Average of the largest values in multiple columns
  7. SQL Print the name of all Employees together with the name of their supervisor
  8. How to select the nth row in a SQL database table?
  9. Does SQL Server Offer Anything Like MySQL’s ON DUPLICATE KEY UPDATE
  10. Storing JSON in database vs. having a new column for each key
  11. Stored Procedure with optional “WHERE” parameters
  12. sql join two table
  13. Why do results from a SQL query not come back in the order I expect?
  14. When to use SELECT … FOR UPDATE?
  15. Best practices for SQL varchar column length [closed]
  16. Relationship between catalog, schema, user, and database instance
  17. Does mysql have the equivalent of Oracle’s “analytic functions”?
  18. What resources exist for Database performance-tuning? [closed]
  19. How to transpose rows to columns with large amount of the data in BigQuery/SQL?
  20. update columns values with column of another table based on condition [duplicate]
  21. how to cast the hexadecimal to varchar(datetime)?
  22. Is there a way to get the row number in Mysql like the rownum in oracle [duplicate]
  23. Use Composite Primary Key as Foreign Key
  24. How do I list all the columns in a table?
  25. What’s the correct name for an “association table” (a many-to-many relationship) [closed]
  26. Equivalent of MSSQL IDENTITY Column in MySQL
  27. Equivalent of MySQL ON DUPLICATE KEY UPDATE in Sql Server
  28. What are the max number of allowable parameters per database provider type?
  29. Convert SQL Server query to MySQL [duplicate]
  30. comparison of truncate vs delete in mysql/sqlserver [duplicate]

Leave a Comment