sql - Table returning multiple rows for single join match -

i have table called "items"

    itemnumber | material ------------------------------      1234      |  cast      234a      | tool plate

and table called "material"

    material    |  process --------------------------------     cast        |  anodize     tool plate  |  blah

i doing select on tables join:

select process,material.material items inner join material on items.material=material.material  items.itemnumber = '1234'

and return of

anodize   |cast tool plate| cast

'cast' has match of 'anodize', returning each combination. i've tried every join type know of , produces same results. doing wrong?

other typo item.material (it should items.material), query works fine, assuming have presented facts correctly data.

try out demo here: sql fiddle

Brant