Get the Values with null for all dates

try below,

CREATE TABLE #T1
( Item varchar(50),
  SalesDate Datetime,
  Quantity int
)

INSERT INTO #T1 VALUES ('Item1', '2013/02/01', 3) 
INSERT INTO #T1 VALUES ('Item2', '2013/02/01', 5)
INSERT INTO #T1 VALUES ('Item1', '2013/02/02', 2)
INSERT INTO #T1 VALUES ('Item1', '2013/02/03', 6)
INSERT INTO #T1 VALUES ('Item2', '2013/02/03', 4)



declare @SaleDetails TABLE(date_col datetime)
insert @SaleDetails select '2013/02/01'
insert @SaleDetails select '2013/02/02'
insert @SaleDetails select '2013/02/03'

declare @ItemDetails TABLE(Item varchar(10))
insert @ItemDetails select 'Item1'
insert @ItemDetails select 'Item2'

select I.Item,S.date_col,T.Quantity from 
@ItemDetails I
inner join @SaleDetails S
ON 1=1 
left join #T1 T
ON T.Item=I.Item and S.date_col=T.SalesDate

---

Please use Marked as Answer if my post solved your problem and use Vote As Helpful if a post was useful.