SELECT id, sheet_id,lockset_no,opcode,lockType,sheet_lng,sheet_lat,start_date,end_date ,remark FROM key_sheet,lockset.lockset where id in (select min(id) from key_sheet where key_sheet.state=1) AND lockset.lockset.lockset_id in (select lockset_relevancy.lockset_id from key_sheet,key_info,lockset_relevancy where key_sheet.user_id = lockset_relevancy.user_id and key_info.key_id = key_sheet.key_id);
多条记录中取一条
最新推荐文章于 2019-09-11 08:49:49 发布