From 365b87f3e8fe3773955e84dcd9ea4224e8f92c06 Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期二, 27 十二月 2022 10:35:52 +0800
Subject: [PATCH] 12.27

---
 data/ts.sql |    8 +++++---
 1 files changed, 5 insertions(+), 3 deletions(-)

diff --git a/data/ts.sql b/data/ts.sql
index 722179e..f06fef8 100644
--- a/data/ts.sql
+++ b/data/ts.sql
@@ -88,12 +88,14 @@
 select * from lf.sys_user 
 select * from lf.sys_role_user
 select * from lf.sys_role
+
 select c.*, fn_rec_query(c.depid, 'dep') depName,fn_uname(c.create_user) createName,fn_uname(c.update_user) updateName
-from lf.sys_user a inner join lf.sys_role_user b on a.id = b.userid
-inner join lf.sys_role c on b.roleid = c.id
+from lf.sys_user a inner join lf.sys_role_user b on a.id = b.userid inner join lf.sys_role c on b.roleid = c.id
 where a.id = 1;
 
-
+select a.*, fn_rec_query(a.depid, 'dep') depName,fn_uname(a.create_user) createName,fn_uname(a.update_user) updateName
+from lf.sys_user a inner join lf.sys_role_user b on a.id = b.userid inner join lf.sys_role c on b.roleid = c.id
+where c.id = 15
 
 
 

--
Gitblit v1.9.3