Posted by Paul on 11/16/05 23:49

To do this it's necessary to know what your tables look like. In a
normalised db of this type you'd probably have 3 tables involved

EMPLOYEES
PAY RATES
TIMESHEET

with proper primary and foreign key relationships. If you have this kind
of arrangement then it's as easy as falling off a log. If not then it
depends what data you actually do have.





--
Using Opera's revolutionary e-mail client: http://www.opera.com/mail/

• Next in forum: Re: SQL statement to compute employee pay for a year at different pay rates
• Prev in forum: Re: sql query update
• Thread view: Re: SQL statement to compute employee pay for a year at different pay rates

[Reply to this message]