Join problem

[piglet]

Hi! I try to pull out data from three tables, and face a problem.

Here is my query:

SELECT Census2000_1.GEO2000,
[2003_Full].FIPS,
SUM(2003_Full].DEPSUMBR) AS TOTAL,
V032006.GEO2000 AS V032006
FROM [2003_Full] FULL OUTER JOIN
Census2000_1 ON FDIC.dbo.[2003_Full].FIPS = Census2000_1.GEO2000
FULL OUTER JOIN
V032006 ON FDIC.dbo.[2003_Full].FIPS = V032006.GEO2000
GROUP BY [2003_Full].FIPS, Census2000_1.GEO2000,V032006.GEO2000


I can get three tables match one another if the data exists in all three tables.

But with data which only exists in two of the tables, it'll show up in the table and again in the other table, like the following example:



1

7

9

1

7

9

2 2 2

3 3 3

What can I do to make it in order and leave blank if the data doesn't exist in that file.



1 1

2 2 2

3 3 3

7 7

9 9

Does anyone have an idea to solve the problem?

Thanks in advance