Hello,
Consider this simple query:
SELECT number1, number2
FROM NUMBERS LEFT JOIN ITEMS
ON NUMBERS.number1 = ITEMS.number2
Now, suppose NUMBERS Contain numbers from 1 till 10 for each year it has and ITEMS contains numbers from 1 till 9 for each year it has. I would expect the result to bring me 10 with NULL for each year, yet I receive only 9 results, like I did an INNER JOIN and not LEFT JOIN.
Both fields are the exact type and container size.
What could be the problem here?
Consider this simple query:
SELECT number1, number2
FROM NUMBERS LEFT JOIN ITEMS
ON NUMBERS.number1 = ITEMS.number2
Now, suppose NUMBERS Contain numbers from 1 till 10 for each year it has and ITEMS contains numbers from 1 till 9 for each year it has. I would expect the result to bring me 10 with NULL for each year, yet I receive only 9 results, like I did an INNER JOIN and not LEFT JOIN.
Both fields are the exact type and container size.
What could be the problem here?