sql语句关联字段查询

SELECT
 t.*,
 a.`name`
FROM
 `t_news` t
 LEFT JOIN t_category a
 ON t.category_id = a.category_id
 LIMIT 1,5

原文地址:https://www.cnblogs.com/wangshengli520/p/11213389.html