在开发财务软件时如何建库?

[williw]

各位打虾你们好!
在开发财务软件时是每个一级会计科目做一张表,二级会计科目做为字段;还是每个一级,二级会计科目各做一张表.(此项目会计科目共六级)
另外, 有三张表 s1,s2,s3 如下:
s1: s_id(char) s_g1(int) s2: s_id s_g2 s3: s_id s_g
1 90 1 80 1
2 80 2 70 2
是否可以用 SQL 语句建立视图显示如下:
s_id s_g1 s_g2 s_g
1 90 80 170
2 80 70 150
请附代码.
如果不能建立,那么用pb如何实现.

[pengdali]

select s1.s_id,s1.s_g1,s2.s_g2,s1.s_g1+s2.s_g2 as s_g from s1,s2 where s1.s_id=s2.s_id

[pengdali]

select s3.s_id,s1.s_g1,s2.s_g2,s1.s_g1+s2.s_g2 as s_g from s1 join s2 on s1.s_id=s2.s_id right join s3 on s3.s_id=s1.s_id

[williw]

这样无法存储

[caiyunxia]

财务的会计科目有用户定呀
长度，级数，按上面的表不灵活
可以按树型结构作