x**z 发帖数: 2437 | 1 TABLE A :
Field AA(ID),AB(Category), AC(Number),AD
Table B:
Field BA(Category), BB(Number)
Relationship
A--B (many to one not enforced, Not all A category is in B table) so A left
join B is what I need)
Result I need:
A.AA, A.AB, A.AC, B.BB, A.AC/Sumif(B.BB is not null, A.AC), A.AC/Sumif(B.
BB is not null, A.AC)* Sum(AD)
咋写比较快? A》60K record. B> 2000 Record.
Thanks! |
|