Left join

[Anetal]

Hi. I am having trouble joining tables. I want to add data to one table from the other after the key: year and number. I do not have some years in the second table, and yet when connecting, I see values. Why is this happening?


Table 1

year	number
2020
2021
2019	1
2019	2

year	Value	number
2019	2	1
2019	10	2

Year	number	Wyr1
2019	1	TRUE
2020		FALSE
2021		FALSE
2019	2	FALSE

Hi. 44llI a

year	Value	number
2019	2	1
2019	10	2

m having trouble joining tables. I want to add data to one table from the other after the key: year and number. I do not have some years in the second table, and yet when connecting, I see values. Why is this happening?

[Minty]

It's not very obvious what you really want but I'll stab a guess that this might be what your after;

SELECT [table 1].year, [table 1].number, [table 2].Value
FROM [table 1] LEFT JOIN [table 2] ON ([table 1].number = [table 2].number) AND ([table 1].year = [table 2].year);

[ssanfu]

I realize that your example is probably something you threw together, but "Year", "Value" and "Number" are reserved words and shouldn't be used for object names.
Just sayn' .