#HASHBANE


SELECT p.`ProductCode`, p.`ProductName`,  

       r.`ReviewTitle`, r.`Rate`, r.`ReviewDescription`,
       r.`LastModified`
FROM `Products` p
INNER JOIN `Reviews` r ON r.`ProductCode` = p.`ProductCode`
WHERE r.`LastModified`
BETWEEN '5/12/2012 0:00'
                        AND '5/12/2012 23:59'

ORDER BY r.`LastModified` DESC