When I use the following query

select t.trantype
FROM rpttrantype t

where t.trantype = 33 or t.trantype =35

I got the list

trantype
--------
33
35

(2 row(s) affected)

this is correct because it is only two records (33 and 35) in the db.


but when I tried to join two tables using the following

select t.trantype
FROM rpttrantype t
JOIN rptstatecode s
on t.rttkey = s.rttkey

where t.trantype = 33 or t.trantype =35

the result is different

trantype
--------
33
35
35
35
35
35
35
35

(8 row(s) affected)

I don't know why??? I only expect two records (33 and 35) listed

Thanks