79646719

Date: 2025-05-31 15:00:10
Score: 0.5
Natty:
Report link

Docs

The LEFT join returns all rows in the "left" table. Adding the constraint on customers id isn't going to change that fact.

If you want to filter those rows, you need to use a where clause:

SELECT * FROM customers
LEFT OUTER JOIN salesman
ON customers.id = salesman.id
WHERE customers.id = 2
Reasons:
  • Low length (0.5):
  • Has code block (-0.5):
  • Low reputation (0.5):
Posted by: Zhe