INSERT askers (asker_id,asker_name,check_intime,role_name)
SELECT e.user_id asker_id,e.login_name asker_name,e.createtime check_intime,f.role_id role_name FROM (SELECT a.user_id,a.login_name,b.role_id,a.createtime FROM (SELECT * FROM users ) a JOIN (SELECT * FROM userroles) b on a.user_id= b.user_id ) e JOIN
(SELECT c.role_id,c.role_name,d.user_id FROM (SELECT * FROM roles ) c JOIN (SELECT * FROM userroles) d on c.role_id=2 and d.role_id=2) f
on e.user_id= f.user_id AND e.role_id= f.role_id WHERE e.user_id NOT IN (SELECT asker_id FROM askers);
sql语句 连表查询多张表添加到另外一张表
最新推荐文章于 2022-12-31 19:18:30 发布