Advance Records Selection

shoaibmunir · 09-25-2009, 11:41 PM

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!

Village Idiot · 09-26-2009, 12:37 AM

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

shoaibmunir · 09-26-2009, 07:27 AM

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.