Select Query With In Statement
It's not completely clear what you're trying to do, but this might help:

declare @Data table (
    nID varchar(16)
  , name varchar(16)
  , saletotals float
  , saledate date
)

declare @GiveMeSaleTotals table (
  nID varchar(16)
, datetocheck date
)

Insert into @Data (nID, name, saletotals ,saledate) Values
 ('111eee', 'Blue', '13.22', '01/01/2016')
,('111eee', 'Blue', '44.11', '01/03/2016')
,('111eee', 'Blue', '22.11', '01/08/2016')
,('222ffff', 'Red', '11.11', '01/11/2016')
,('222ffff', 'Red', '22.10', '01/22/2016')
,('4444ffff', 'Red', '22.10', '12/05/2016')
,('4444ffff', 'Red', '21.10', '12/05/2016')

insert into @GiveMeSaleTotals (nID, datetocheck) values ('4444ffff', convert(date,GetDate()))

select d.*
  from @Data d 
    inner join @GiveMeSaleTotals g on d.nid=g.nid and d.saledate=g.datetocheck


results in:

    nID              name             saletotals             saledate
---------------- ---------------- ---------------------- ----------
4444ffff         Red              22.1                   2016-12-05
4444ffff         Red              21.1                   2016-12-05


Rextester link: http://rextester.com/SPJQX46455