Advance Records Selection
 

I have a very important assignment its very urgent.

I want that employee who did not got salary. salary will transfer automatically in employees.


my code

Table: Accounts
AccountID = 25
GroupID = 5

Table: Employees

EmployeeID = 1
GroupID = 5

EmployeeID = 2
GroupID = 5

EmployeeID = 3
GroupID = 5

EmployeeID = 4
GroupID = 3

EmployeeID = 5
GroupID = 3

EmployeeID = 6
GroupID = 4



Table: Transferred (Records of that employee who got salary and from witch account salary transferred)

EmployeeID = 1
AccountID = 5


Transfer Salary Script $AccountID = 25 and $GroupID = 5:-


select emp.*, tra.*, emp.EmployeeID as emp_EmployeeID from Employees emp, Transfered tra " & _
'" where emp.EmployeeID<>tra.EmployeeID and tra.AccountID <>$AccountID and emp.GroupID=$GroupID


Please Help!

You're going to have to be more descriptive, we see your database but what exactly are you trying to do?

I want transfer salary to all group 5 employees from account#25. maybe employees got multi salary but from one account and just 1 time salary.