从ph_house和ph_info表中调出最新的文章10条,列出标题(title),地区(area)和时间(newstime),
order by newstime limit 10只会写后面这半部分,前面select不会写查了很多资料,似乎是select a.*,b.* from ph_house as a LEFT JOIN ph_info as b,会的帮忙给说一下,应该怎么写,万分感谢
order by newstime limit 10只会写后面这半部分,前面select不会写查了很多资料,似乎是select a.*,b.* from ph_house as a LEFT JOIN ph_info as b,会的帮忙给说一下,应该怎么写,万分感谢
或者
select a.*,b.* from ph_house as a , ph_info as b where a.id=b.id order by newstime limit 10
这样也可以。
FROM ph_house AS a
LEFT JOIN ph_info AS b ON a.id = b.id
ORDER BY onclick DESC
LIMIT 6 MySQL 返回: #1052 - Column 'onclick' in order clause is ambiguous ph_house结构图:ph_info结构图:我觉得a.id=b.id应该不对,因为这个id是唯一的,每增加一篇文章id+1,所以a.id不能等于b.id。我觉得这两张表之间就没有什么可联系起来的,大家来看看吧
FROM ph_house AS a
LEFT JOIN ph_info AS b ON a.id = b.id
ORDER BY onclick DESC
LIMIT 6 MySQL 返回: #1052 - Column 'onclick' in order clause is ambiguous
两个表中都有 onclick 字段。改成如下
SELECT a.* , b.*
FROM ph_house AS a
LEFT JOIN ph_info AS b ON a.id = b.id
ORDER BY a.onclick DESC
LIMIT 6
SELECT a . * , b . *
FROM ph_house AS a
LEFT JOIN ph_info AS b ON a.id = b.id
ORDER BY newstime DESC limit 10
SELECT a . * , b . *
FROM ph_house AS a
LEFT JOIN ph_info AS b ON a.class_id = b.class_id
ORDER BY newstime DESC limit 10
回8楼,请问一张一张表怎么取记录呢? 是10条各取5条吗?如果a表时间有10条记录全部比b表时间新,那各取5条不是达不到效果了吗?
#1052 - Column 'newstime' in order clause is ambiguous
按照错误提示改一下不就行了?SELECT a.* , b.*
FROM ph_house AS a
LEFT JOIN ph_info AS b ON a.class_id = b.class_id
ORDER BY a.newstime DESC limit 10