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!

__________________
==========================================
http://paysha.com/Pakistan/Sialkot/Profiles/100171.html
==========================================