SELECT a.ID,a.[Date],CASE WHEN Seq=1 THEN a.Total ELSE 0.00 END AS Total,b.Item,b.Qty,b.Subtotal
FROM TableA a
INNER JOIN (
SELECT ROW_NUMBER() OVER (PARTITION BY ID ORDER BY Item) AS Seq, *
FROM tableB
)b
ON b.ID = a.ID