Reply to Re: SQL statement to compute employee pay for a year at different pay rates
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/