select distinct Product.userId as userId,Users.loginName as loginName,Users.loginPwd as loginPwd,Users.roleId from Users inner join Product on Product.userId =Users.userId order by Users.roleId
多表的内连接查询,附带取出重复数据的sql语句
最新推荐文章于 2023-04-25 09:20:49 发布