View Single Post

   
  #2 (permalink)  
Old 02-29-2008, 01:56 PM
Paul
 
Posts: n/a
Default Re: SQL statement to compute employee pay for a year at different pay rates

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/
Reply With Quote