记一次用的少且时常忘记的多表联查，不清楚在很多数据时这样的效率怎么样？本人菜鸟一枚，路过的高手可指点一下！THX
SELECT
a.itemid,a.catid,a.areaid,a.title,a.hits,a.thumb,a.linkurl,a.address,a.sponsor,
b.itemid,b.content,
c.catid,c.moduleid,
d.moduleid,d.name
FROM
exhibit AS a
left join exhibit_data AS b ON a.itemid=b.itemid
left join category AS c ON a.catid=c.catid
WHERE
a.title LIKE '%北京%' ORDER BY addtime DESC LIMIT 0,10;
转载请注明原文地址: https://www.6miu.com/read-9923.html
