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 |
|
veena thakur
Starting Member
1 Post |
 Posted - 2008-10-08 : 00:06:20
|
| I have query as follows which is not allowed in SQL server,UPDATE edcx_replytoquery SET qrystatus=1 WHERE fk_id_query = edcx_query.id and edcx_query.flpId = @fidwhere edcx_replytoquery and edcx_query are two diffrent tables. How can I achive the above condition in update statement |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-08 : 00:19:39
|
| [code]UPDATE rtqSET rtq.qrystatus=1 FROM edcx_replytoquery rtqJOIN edcx_query qON rtq.fk_id_query = q.id AND q.flpId = @fid[/code] |
 |
|
|
|
|
|
update query