Use Join
as
Create proc usp_select_items
(
@ComanyName varchar(50),
@City varchar(50),
@LastName varchar(50)
)
as
begin
select *from dbo.Staff s inner join dbo.Items i on s.StaffID=i.StaffID where s.ComapnyName=@ComapnyName and s.City=@City and s.LastName=@LastName
end