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