I received the answer on another forum (thank you Srinika on SQLTeam.com)

select pc.categoryid, MAX(p.datecreated) AS datecreated from photos_categories pc inner join photos p on pc.categoryid=p.categoryid GROUP BY...