select B.SalesID, C.CustomerID, C.CustomerName, B.SerialNo, B.ModelNo,
  A.FirstServiceDate from Services A inner join Sales B on
  A.SalesID = B.SalesID inner join Customer C on
  B.CustomerID = C.CustomerID and
  FirstServiceDate = DATEADD(week, 1, GETDATE())