Good afternoon folks. I am going to write an Update query and a delete query to archive my completed records. I have a large main tableand four small linked tables, my question is would it be better to use a tblname.* or list out all of the fields in each of the tables? Thank you in advance for any assistance.
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!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Best way to write a Update Query?? 1
- Thread starter quest4
- Start date
-
1
- #2
- Thread starter
- #3
Thank you Duane for the response. It has been a while sense I worked with SQL and that brain cell appears to have died. These people change their minds allot and they keep adding things, too. So needless to say I was hoping for the other answer, but I will take your advice and go the long road. Thank you again for the assistance.
- Status
Similar threads
- Question
- Question