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@

[Back to original message]