I have two tables:
Table 1:
Code,No1
A, 1
C, 2
E, 3

Table 2:
Code, No2
A, 2
B, 4
D, 6

I want to join these two tables to give;
Code,No1,No2
A, 1, 2
B, 0, 4
C, 2, 0
D, 0, 6
E, 3, 0

I have been trying varius JOINS & UNION but I cannot find the solution - any suggestions.
Thanks.