Compare 2 table & show detail both table

From: Mal (anonymous_at_discussions.microsoft.com)
Date: 04/29/04 

Date: Thu, 29 Apr 2004 10:46:08 -0700

I have 2 tables and one column in common in both. When I join them and wants some detial from one AND some detail from the other, result is not what I want.

Expl. Table 1 has 500 rec with fields A and B and Table 2 has 300 rec with field A, C and D. Make a joint A->A.
I want to see all 500 rec, but where Table 2 has no records just blank.
When I do this I see I get 800 rec. Why?