|
|
Posted by M@ on 07/12/06 20:42
I am trying to tie two tables of data together and I'm having some
issues.
table 1 has about 1700 rows
table 2 has about 1000 rows
table 3 has about 70
they all have one column in common, provider number.
select a.provider, a.[survey-date], a.tag, a.code, a.[scope-severity],
a.state, a.facilityname,
c.prov, c.defic_dt, c.tag_no, c.scopesev, c.theirnam, b.[name]
from table1 a
inner join table3 b on b.prov = a.provider
inner join table2 c on b.prov = c.prov
problem is, I am getting 35000 rows instead of 2700.
What am I missing?
thanks,
M@
Navigation:
[Reply to this message]
|