问一个简单的Query# Database - 数据库
c*t
1 楼
Table:
Cat Acct num
1 abc x
2 abc y
1 def z
2 deg x
I want to get recordset like:
Acct Cat1 Cat2 num
abc x y x+y
def z 0 z
deg 0 x x
Thx
Cat Acct num
1 abc x
2 abc y
1 def z
2 deg x
I want to get recordset like:
Acct Cat1 Cat2 num
abc x y x+y
def z 0 z
deg 0 x x
Thx