SELECT (@rowNO := @rowNo+1) AS rowno,userid,username,usermobile,countyname,streetname, xiaoquname,useraddress, userscore,userctime FROM
(SELECT user.id AS `userid`,user.name AS `username`,mobile AS `usermobile`,place.name AS countyname, place2.name AS streetname, xiaoqu.name AS `xiaoquname`,address AS `useraddress`, score AS `userscore`,user.ctime AS `userctime` FROM `ims_delixin_user` AS `user`
LEFT JOIN ims_delixin_place AS place ON user.county=place.id
LEFT JOIN ims_delixin_xiaoqu AS xiaoqu ON user.xiaoqu=xiaoqu.id
LEFT JOIN ( SELECT * FROM ims_delixin_place WHERE `level`=2 ) place2 ON user.street=place2.id
ORDER BY id
) a,
(SELECT @rowNO :=0) b下面是报错信息错误码: 1051
Unknown table 'user'
Execution Time : 00:00:00:000
Transfer Time : 00:00:00:000
Total Time : 00:00:00:000 最佳答案
