Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kamalkishore_in
Yak Posting Veteran
76 Posts |
 Posted - 2001-04-19 : 23:14:44
|
| Hi Gurus,This time I think it is a bit difficult for you to do this simple task with single SQL statement ( I mean withouing go through recordset). And if it is possible... you will really help me a lot.My problem is look like this...I have two tables...Say First and Sec....First table contains Field1 and Field2Sec Table Contains Field3 and Field4I wants to update all the records of field4 of the table Sec with the all the records of field2 where First.Field1 = Sec.Field3.I hope you understand....If possible please let me know...Thanks |
|
|
|
|
|
I think Not possible with single SQL stmt