1

Topic: Empty fields because of

Hello!)
Prompt how to make, that the salary and at those who without the award was considered?

SELECT DISTINCT Employees. [Organic number of the employee], Employees. A surname, Employees. A name,
Employees. A patronymic, the Salary. A salary, the Award. Award AS Bonus, the Salary. [Region coefficient],
(A salary. +. The award) *. [Region coefficient] AS the Salary
FROM
(Employees LEFT JOIN Award ON Employees. [Organic number of the employee] =. [Organic number of the employee])
LEFT JOIN Salary ON Employees. [Organic number of the employee] =. [Organic number of the employee]

2

Re: Empty fields because of

(A salary. A salary +>>> Nz (the Award. The award) <<<) *. [Region coefficient] AS the Salary

3

Re: Empty fields because of

__ Michelle;
Thanks! I about such piece did not guess at all)

4

Re: Empty fields because of

Juliana619 wrote:

__ Michelle;
Thanks! I about such piece did not guess at all)

The award, is money. Install in this field a field value by default 0 and there will be no jokes. Only make update this field, and that action will operate by default on new records.