i don't know if i've understood ur problem, anyway try to use DISTINCT:
SELECT DISTINCT isnull(a.column_a, '') as column_a,
isnull(b.column_b, '') as column_b,
isnull(c.column_c, '') as column_c
table_a a, table_b b, table_c c
Select ISNULL(a.data, '') as Table_A , ISNULL(b.data, '') as Table_B, ISNULL(c.data, '') as Table_C
From Table_A a left outer JOIN Table_B b
ON a.[id] = b.[id] left outer JOIN Table_C c
ON a.[id] = c.[id]
I am editing the post because above query will give you all rows which is match with Table_A.
Instead of left outer join, the full outer join will produce required result set. - check the below query.
SELECT ISNULL(a.data, '') As Table_A , ISNULL(b.data, '') As Table_B, ISNULL(c.data, '') As Table_C
FROM Table_A a FULL OUTER JOIN Table_B b
ON a.[id] = b.[id] FULL OUTER JOIN Table_C c
ON b.[id] = c.[id]
Last edited by rajeshpatel; 07-19-06 at 05:57.
Reason: query edited...