>I have a table which contains accounting data. In that table I have a field which contains the responsible branch office and another field for the staff initials. In a second table (staff) I have the staff initials with the corresponding staff name.
>
>I would like to have a report which shows the revenue for each staff member within a branch. I have the first table ordered by office+staff_initials to do this grouping and everything is ok but I would like the name also printed in the report that is associated with the staff initials.
>
>What can I do ?
Select branch.office,branch.staff_in,sum(branch.revenue),staff.name ;
From branch,staff ;
Where branch.staff_in=staff.staff_in ;
Group by 1,2
Edward Pikman
Independent Consultant