从多个表中获取倍数字段值 [英] getting multiples field value from multiple tables

问题描述

大家好！
我有六个表-umrf, list, mod, fun, user, rol
每个表的字段如下.

Hi to all!
I have six tables - umrf, list, mod, fun, user, rol
Fields of each table are as follows.

umrf (uid, lid)
list (lid, mid, fid, rid)
mod (mid, mname)
fun (fid, fname)
rol (rid, rname)
user (uid, uname)

仅给出uid
我必须显示lid, mname, rname, fname
我也为此创建了一个查询，但是其中有很多问题.
OP中的存储过程，已从注释中删除[/Edit]

given only is uid
and I have to display lid, mname, rname, fname
I also create a query for this but there are many problems in that.
Stored Procedure from OP, removed from comments[/Edit]

create procedure proc_mrf_discription_user (@uid nvarchar (50)) 
as 
  select sec_modules.modname_vc, sec_roles.rolename_vc, sec_functions.functionname_vc 
  from sec_umrf_details 
  left join sec_mrf_details on sec_umrf_details.mrfno_int = sec_mrf_details.mrfno_int 
  left join sec_modules on sec_modules.modid_int = sec_mrf_details.modid_int 
  left join sec_roles on sec_roles.roleid_int = sec_mrf_details.roleid_int 
  left join sec_functions on sec_functions.fnid_int = sec_mrf_details.fnid_int 
  where sec_umrf_details.userid_vc = (@uid) 
  group by sec_modules.modname_vc, sec_roles.rolename_vc, sec_functions.functionname_vc

推荐答案

使用JOINS应该可以帮助您解决问题.

Using JOINS should help you solve your problem.

这篇关于从多个表中获取倍数字段值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！