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 |
jim_jim
Constraint Violating Yak Guru
306 Posts |
Posted - 2013-01-17 : 09:17:34
|
Hi All I'm trying to update a datetimefeild in a table from a datetimefeild in another table based on a cretia.Both the tables can be joined on a feild called requesnoWill the below query work okUpdate CR Set CR.contractdate = select CC.contractenddate from CC where FROM Customer_Request CR Inner join CustomerContracts CCON CR.requestno = CC.requestnowhere CC.Indicator = 'Y' and requestno in Thanks |
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2013-01-17 : 09:30:37
|
update CRset contractdate = CC.contractenddatefrom Customer_Request CR inner join CustomerContracts CCON CR.requestno = CC.requestnowhere CC.Indicator = 'Y' and CC.requestno in (...?...) Too old to Rock'n'Roll too young to die. |
|
|
jim_jim
Constraint Violating Yak Guru
306 Posts |
Posted - 2013-01-17 : 09:58:27
|
Thank Youquote: Originally posted by webfred update CRset contractdate = CC.contractenddatefrom Customer_Request CR inner join CustomerContracts CCON CR.requestno = CC.requestnowhere CC.Indicator = 'Y' and CC.requestno in (...?...) Too old to Rock'n'Roll too young to die.
|
|
|
|
|
|