在行和列中使用字段 [英] use field in row and column

问题描述

嗨
我有这些桌子



表1：部门

Hi I Have these tables

Table1: Dept

int DeptID
nvarchar2 dept_caption

值

values

1 Dept1
2 Dept2
3 Dept3

表2：请求

Table2: Request

int RequestID
int Requester
int Responsible

RequestID   1   2  3 4 5 6 7
Requester   1   2  1 3 3 3 4
Responsible 2   3  2 1 3 1 4

如何显示每位负责人的请求数？

How can I show count of request for every responsible?

 req\responaible      Dept1   Dept2   Dept3   ...
Dept1                 2        14       5
Dept2                 3        22        4
Dept3                 4        3        2 

best rgds

best rgds

推荐答案

可以此格式出现



我的数据是：



Req_Department || Responsible_dept



Department1 ||部门1

部门1 || Department4

Department2 || Department2

Department3 ||部门1

部门2 || Department3

Department3 ||部门1

部门4 ||部门3



如何从数据中获得此资产



向负责部门索取req / res请求数





Req_Dept / Resp_dept ||部门1部门2部门3部门4 ....



部门1 || 1 0 0 1

Department2 || 0 1 1 0

Department3 || 2 0 0 0

Department4 || 0 0 1 0

。

。

。

。





best rgds

can present in this form

My data is:

Req_Department || Responsible_dept

Department1 || Department1
Department1 || Department4
Department2 || Department2
Department3 || Department1
Department2 || Department3
Department3 || Department1
Department4 || Department3

How can I get this resualt from data

count of req/res request to responsible department


Req_Dept/ Resp_dept|| Department1 Department2 Department3 Department4 ....

Department1 || 1 0 0 1
Department2 || 0 1 1 0
Department3 || 2 0 0 0
Department4 || 0 0 1 0
.
.
.
.


best rgds

谢谢

请求者是deptid fielin dept table的外键

负责是dept表中deptid字段的外键

谢谢

thanks
requester is foreign key with deptid fielin dept table
responsible is foreign key with deptid field in dept table
thanks

这篇关于在行和列中使用字段的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！