multiple same records in join
Posted on 2007-10-04
I have a general question that seems hard to explain, I want to create a join btwn 3 tables; however, when I run my query I have multiple copy records appearing of the same record. Even when I cut the query down to a two table join with one field this is happening. I'm sure there is something fundamentally wrong with my logic that is making this happen. I would like the query to only display each record once. There aren't any PK's or relationship btwn the tables but they reside in the same DB. Can anyone explain why this would happen?
b.tn, b.dist, b.al, b.si, b.bld, b.status, b.rcd, b.ct, b.cat, b.wfr,
b.ap, b.rap, b.dp1id, b.dp1tm, b.dp2id,
b.dp2tm, b.dist + b.bld as b_tnarea,
tbl_calrs_archive as a
join tbl_OpenCalrsData as b
on a.tn = b.tn and a.rcd = b.rcd
left outer join CALRSnnx as c
on b.dist + b.bld = c.tnarea COLLATE Latin1_General_CI_AS
b.ct is null
and left(a.sa, 4) = '!MC!'
order by b.tn