Forum Discussion

danielmbaquero's avatar
danielmbaquero
Regular Visitor
6 years ago

Calculate time difference based on id and sequence number in different tables

Good day community,   I have two tables. The first one is called "An_Start" and it shows me the time a particular operation (OperationID) start the analysis. In other table called "Reg_Start" I hav...
Need Help
jthomson's avatar
jthomson
Icon for Solution Sage rankSolution Sage
6 years ago

If you make a new column in each table concatenating the id and sequence numbers (with some sort of separator i.e. your top line is something like 1-1) then you should be able to merge or relate the tables, it's then just a case of some sort of datediff formula