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.
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement