From 2dd6e42410ef964068ae9e9134cf75c760dc6306 Mon Sep 17 00:00:00 2001 From: 13693261870 <252740454@qq.com> Date: 星期二, 11 十月 2022 12:44:04 +0800 Subject: [PATCH] 1 --- data/db.sql | 3 ++- 1 files changed, 2 insertions(+), 1 deletions(-) diff --git a/data/db.sql b/data/db.sql index 6f8745e..f677bf2 100644 --- a/data/db.sql +++ b/data/db.sql @@ -1022,8 +1022,9 @@ select fn_rec_query(10, 'dir'); select fn_rec_query(28, 'dir'); select * from lf.sys_dir order by id; ------------------------------------------------------------------------------------------------------ e. +select a.*, fn_rec_query(a.depid, 'dep') depName from lf.sys_user a order by a.id; +----------------------------------------------------------------------------------------------------- e. -- Gitblit v1.9.3