update 2 columns by doing inner 2-column query

Posted on 16th Feb 2014 07:03 pm by admin

Hi,
is something like this possible?

update contract_all set col1,col2 =
(SELECT col1,col2 FROM tab1 WHERE id = 141 and status='a')
where co_id=141;

Thanks

Your Answer:

Login to answer

Other forums

Syntax Help
I'm trying to make a form that edits a php file which contains config settings. I'm using strings t

Operator precedence assistance.
I did a quick Google search and couldn't quite find the answer I wanted in terms I could understand,

ALV List Display to point to another report on Double Click
Hi,

I want my ALV List Display to point to another report on Double Click on its line ite

2 things: enter doesn't work in IE & empty form
i have this search form that works well except for 2 things.

1) on IE when i hit enter instea

using variables in another page
I have a test database set up on localhost. I have a form that I can type a name into, hit the butto

getting a website's source code as a variable? How?
Hey guys, is there any way for me to get the source code of a website as a variable for me to work w

Simple Variable Question
Hi everyone.... again,

I am really getting into php still. Learning more every day. I love it

Preg_match unknown modifyer
Hello,

Im trying to write a little script for my forums i need to get the reply from my forum

Need help with unexpected T-STRING error
I'm a newbie and I'm still learning PHP. However this error has me stumped. I've googled, searched t

please help
HTML Code:

Code: <span id="ctl00"><span>