I am new to SQL and trying to apply a concept of Joins in MS-access.
I have two tables Table 1 and Table 2:
I want a query which will create a Table 3:
Ideally i want all the data from both tables but wherever the ID's are matching in both tables, the category should become '3'
I have attached the samples for your reference