I have tables say tbl1, tbl2, tbl3
I am joing this table to get back some recordsets
select a.col1
b.col2
c.col3
from tbl1 a inner join tbl2 b
on a.col1 = b.col2
inner join tbl3 c
on b.col1 = c.col2
the resultset will teturn
col1 col2 col3
1370 1446 aa
1370 1446 aa
216 1549 bb
1583 1549 cc
216 1549 bb
1583 1549 cc
Here is my problem I don't want col3 to be repeated, if it repeats, it should put null instead
therefore I want the recordset to be
col1 col2 col3
1370 1446 aa
1370 1446 Null
216 1549 bb
1583 1549 cc
216 1549 Null
1583 1549 Null
how can I do that
thanks
I am joing this table to get back some recordsets
select a.col1
b.col2
c.col3
from tbl1 a inner join tbl2 b
on a.col1 = b.col2
inner join tbl3 c
on b.col1 = c.col2
the resultset will teturn
col1 col2 col3
1370 1446 aa
1370 1446 aa
216 1549 bb
1583 1549 cc
216 1549 bb
1583 1549 cc
Here is my problem I don't want col3 to be repeated, if it repeats, it should put null instead
therefore I want the recordset to be
col1 col2 col3
1370 1446 aa
1370 1446 Null
216 1549 bb
1583 1549 cc
216 1549 Null
1583 1549 Null
how can I do that
thanks