$sql = "SELECT a.year,a.guid,a.description,b.description AS pic_des,c.year AS pic_year,c.month AS pic_month,c.day AS pic_day,c.file AS pic_file
FROM m_honor2_honor2 a LEFT JOIN m_honor2_pics b ON a.guid = b.honor2_guid
LEFT JOIN sys_file c ON b.image= c.guid
WHERE a.year = $year
ORDER BY a.order_is DESC";
三表关联查询-多次LEFT JOIN...ON
最新推荐文章于 2023-10-21 06:56:18 发布