E C.

See my answer above in the reports section. You may have better luck if you post your question in only one category and give yourself a day to receive answers. Then repost if no-one has seen it.

Welcome to the UT!

>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.