记一次用的少且时常忘记的多表联查,不清楚在很多数据时这样的效率怎么样?本人菜鸟一枚,路过的高手可指点一下!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;