{dede:sql sql="SELECT a.id,b.id FROM list AS a,type AS b WHERE a.key=1 and a.type_id=b.id order

2025-01-20 21:10:58
推荐回答(1个)
回答1:

sql语句改成这样子:
SELECT a.id AS aid, b.id AS bid FROM list AS a,type AS b WHERE a.key=1 and a.type_id=b.id order by a.id desc LIMIT 0,3

数据出来之后直接按字段名来得到数据,aid或者bid