How to join tables

[dollygg]

I have two tables:
table A:

a period1 period 2 perod 3


c period1 period 2 perod 3
d period1 period 2 perod 3


Table B:

a period4
b period4
d period4


Final result wanted:
a period1 period 2 perod 3 period4
b period4
c period1 period 2 perod 3
d period1 period 2 perod 3 period4

[ranman256]

table A is designed wrong, it should be
A period1
A period2
A period3

but join the 2 tables on 1st col. bring ALL of table A, add table B to the end.
make this an OUTER JOIN in order to see all the records.