I using SQL to select the records I wanted as follow :
SELE pay.staff,pay.salary,staff.tel ;
FROM pay,staff ;
WHERE pay.staff = staff.staff ;
INTO CURSOR temp
The problem is if staff have 2 tel, when I run the report the average salary will be incorrect.
Can anyone help me to find out the solution
Thank u.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only