Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. torhalvar

    Joining tables with timestamp

    It is possible, but a new salary is supposed to be effective from 00:00 and usually there is no work over midnight. So there is basically only one salary per start-end.
  2. torhalvar

    Joining tables with timestamp

    Hi, first of all I'm sorry for my English. I am building a database were I want to join three tables. Employee: ID varchar(7) LastName Forename Address Zip Email .... employee_salary: ID int(50) employeeID varchar(7) (key from employee) salary_from (timestamp) salary (double)...

Part and Inventory Search

Back
Top