mysql join 疑问?
发布网友
发布时间：2022-04-08 04:27
共1个回答
热心网友
时间：2022-04-08 05:57
使用别名
SELECT fcym_jokes.id fj_id,fcym_userid fu_id FROM `fcym_jokes` inner join fcym_user on fcym_jokes.uid = fcym_user.id ORDER BY time DESC LIMIT 0,10追问但是用thinkphp里的方法是怎么写的呢？求解
追答$wish = $JOKES)->field('fcym_jokes.id fj_id,fcym_userid fu_id')->join('inner join fcym_user on fcym_jokes.uid = fcym_user.id'->order('time DESC')->limit($limit)->select();
应该有field这个方法，获取指定字段的
