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.