Tom Brown (5/27/2009)

---

So if an update needs to take place you want to delete all records from table2?

or only specific records from table2. If its the latter, then how...

Tom Brown (5/27/2009)

---

In case Frank's answer isn't completely clear you can't do it in one statement, you, but you can do it in one script, you need to use...

Frank Kalis (5/27/2009)

---

Have a look at the EXISTS () clause in Books Online. You can test if at least 1 row matches the criteria and if so do the UPDATE...