EasyCFM.COM ColdFusion Forums / Oracle Related Issues / Updating Multiple tables

   Reply to Discussion | New Discussion << previous  
Posted By Discussion Topic: Updating Multiple tables

book mark this topic Printer-friendly Version  send this discussion to a friend  new posts last

cdbymike
08-08-2004 @ 11:07 PM
Reply
Edit
Profile
Send P.M.
My Gravatar!
Powered by Gravatar
Junior Member
Posts: 97
Joined: Jul 2004

This is quite difficult for me to explain and lenghty.

I have 2 table where I need to update the records for individuals based on their department.

Tables:
TT_HISTORY.ID
TT_HISTORY.STARTTIME
TT_HISTORY.ENDTIME
TT_HISTORY.STATUS_ID

TT_Current.EMPLOYEE_ID
TT_Current.STATUS_ID

CS_Employee.Employee_ID
CS_Employee.Name
CS_Employee.Department_Code
CS_Employee.Manager_ID

Basically, at 11:59pm, I want all employees that have a STATUS_ID = 0 changed to 5 with the current time for all employees that are in department 9812.

I hope this makes sense. Can someone help me out? I can do it in ACCESS, but I do not know how in oracle and this is where my data is housed.
Question


Website Designed and Developed by Pablo Varando.