dt_gry Posted October 13, 2008 Share Posted October 13, 2008 I am trying to copy a record from table_1 to table_2 adding endtime to table_2 in the same db and then delete the record from table_1 I have googled till I am blue in the face and I am getting no where. Here are my table fields table_1 'Uname' 'CurDate' 'StartTm' 'IPadd' table_2 'Uname' 'CurDate' 'StartTm' 'EndTm' 'IPadd' Thanks Guys, dt_gry Quote Link to comment Share on other sites More sharing options...
fenway Posted October 13, 2008 Share Posted October 13, 2008 Like with INSERT INTO ... SELECT WHERE? Quote Link to comment Share on other sites More sharing options...
dt_gry Posted October 13, 2008 Author Share Posted October 13, 2008 Yup, one more detail is that EndTm is held in a variable. any ideas. thanks! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.