Code:
SELECT Retail Tran DateTime, Product Department Name, Product Quantity, Product Retail Price 
FROM Product Sales Detail 
WHERE Product Department Name = 'Meter' 
	AND Retail Tran DateTime = DATEADD(DAY, -1, CURRENT_TIMESTAMP)
ORDER BY Retail Tran DateTime;
Is the code as it shows? with a table called "Product Department Name" separated in three words and column names like "Retail Tran DateTime" also separated in several words? Check names, please.