如何用 Count/Sum 函数呢?
本帖最后由 QQ342151559 于 2013-07-31 23:22:39 编辑 有4个表: T_Name;M_Name;C_History;P_History
表T_Name:
T_IDNameType
0102DW0101
0103DW0201
0204DW0302
....
M_IDNameType
01001P101
01003P201
02001P302
....
C_ID T_ID
201201020102
201201030102
201201040102
201201050103
201201060204
201201070204
201201080204
201201090103
201201100103
....
C_ID M_IDP_ID
20120102010010
20120103010010
20120104010011
20120105010031
20120106020010
20120107020012
20120108020010
20120109020011
20120110020022
...
T_IDM_IDP_IDCount_PCount_TotalRatio
01020100102367%
01020100111333%
0102010012030%
0102010030000%
0102010031000%
0102010032000%
0103010010000%
0103010011000%
0103010012000%
0103010030020%
01030100311250%
01030100321250%
02040200102450%
02040200111425%
02040200121425%
....