select p.projectName, t.ThingNamefrom projects pjoin projectThinglink l on l.projectId = p.projectIdjoin thing t on t.thingId = l.thingIdwhere l.createdDate =( select max(l2.createdDate) from projectThinglink l2 where l2.thingId = l.thingId);
注意：评论后已更正
