表数据库中的总和值 [英] sum value in table database

问题描述

数据库包含表中的内容

ihave data base contain from table

employee table
  empno
  ename
  val_sal

adittion work
  empno
  adwork

comm
  empno
  comm

bunish
   empno
   bun_val

salary
  empno
  sal

在我的数据库中将值(+ adwork，+ comm，-bun_val，+ sal)关闭时添加val_sal
在员工自动iuse访问数据库的薪水中包含(+ adwork，+ comm，-bun_val，+ sal)
我无法使用一张桌子，因为我使用了不同的用户
感谢

iwant while add value off(+adwork,+comm,-bun_val,+sal)in my data base the val_sal
contain (+adwork,+comm,-bun_val,+sal) in salary of employee automatical iuse access data base how iwork that
i can''t use one table becuse iuse different user
thank

推荐答案

您的问题令人困惑，并且没有很好地解释，但是假设您想要的是这样:
1)记录员工的基本(正常)工资
2)记录额外工作的额外收入
3)记录费用要从总薪水中扣除(取消吗?)
4)记录通讯"工作的额外收入(无论是什么佣金?)

这样一来，最好有一个用于员工的表和一个用于收入项目的表.每个收入项目都有一个类别(来自第三张表)，"addition_work"，"bunish"，"comm"，"salary"等.
然后，您的总收入将是一个查询，而不是使用SUM(收入项目表中的字段)并使用分组依据进行各种报表效果的表.
一段时期(例如一个月，一周)等似乎也很合理.

然后看看此 [ ^ ].

M

Your question is confusing and not very well explained, however, assuming that what you want is this:
1) To record the basic (normal) salary for an employee
2) Record extra income for additional work
3) Record expenses to be removed from total salary (bunish?)
4) Record extra income for ''comm'' work, (whatever that is, commission?)

Then you would be better of having a table for employees and a single table for income items. Each income item would have a category (from a third table), ''addition_work'', ''bunish'', ''comm'', ''salary'' etc.
Your total income would then be a query not a table using SUM(field from income items table) and using Group By for various reporting effects.
A period (e.g. month, week) etc. would seem sensible also.

Then have a look at this[^].

M

这篇关于表数据库中的总和值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！