How can a LEFT OUTER JOIN return more records than exist in the left table?

by

The LEFT OUTER JOIN will return all records from the LEFT table joined with the RIGHT table where possible.

If there are matches though, it will still return all rows that match, therefore, one row in LEFT that matches two rows in RIGHT will return as two ROWS, just like an INNER JOIN.

EDIT:
In response to your edit, I’ve just had a further look at your query and it looks like you are only returning data from the LEFT table. Therefore, if you only want data from the LEFT table, and you only want one row returned for each row in the LEFT table, then you have no need to perform a JOIN at all and can just do a SELECT directly from the LEFT table.

More Related Contents:

  1. Is it possible to write single query on two table which are not connected to each other?
  2. Get top 1 row of each group
  3. How can I do an UPDATE statement with JOIN in SQL Server?
  4. SQL update query using joins
  5. How to update two tables in one statement in SQL Server 2005?
  6. Referring to a Column Alias in a WHERE Clause
  7. SQL query to select dates between two dates
  8. Convert Month Number to Month Name Function in SQL
  9. Create a date from day month and year with T-SQL
  10. Selecting COUNT(*) with DISTINCT
  11. How to return multiple values in one column (T-SQL)?
  12. Generate a resultset of incrementing dates in TSQL
  13. Getting result of dynamic SQL into a variable for sql-server
  14. How to get difference between two rows for a column field?
  15. Better techniques for trimming leading zeros in SQL Server?
  16. SQL – Subtracting a depleting value from rows
  17. What’s the best way to select the minimum value from several columns?
  18. Concatenate values based on ID
  19. Is it possible to select sql server data using column ordinal position
  20. SELECT FOR UPDATE with SQL Server
  21. SQL Server 2005 ROW_NUMBER() without ORDER BY
  22. How to split string using delimiter char using T-SQL?
  23. Can an INNER JOIN offer better performance than EXISTS
  24. OPENXML with xmlns:dt
  25. SQL server select distinct rows using most recent value only
  26. Eliminate and reduce overlapping date ranges
  27. Cumulative Total in MS Sql server [duplicate]
  28. Why do SQL Server Scalar-valued functions get slower?
  29. Memory effective way to read BLOB data in C#/SQL 2005
  30. When to use EXCEPT as opposed to NOT EXISTS in Transact SQL?

Leave a Comment