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

Filename like the user name
I am creating a form and storing the values in file. Could anyone please tell me how to write a code

Not connecting to DB using ruby, error:env.c:257:in oci8lib.so: ORA-12154:
Hi All,

I am trying to connect to the database server from the client server using ruby and f

image upload, resize THEN submit form
Ok so I have a form that requires the user to upload an image, and then do something with that image

Generating unique numbers using php
Hi,
I need help in generating unique number using php.I tired using rand() in php.But, by using r

Email Processor
I have a few questions so this post will be a larger one! Sorry, but I'm a bit of a PHP newbie so be

form variables from database help.
Hi all,

I would like to have a form that gives you options based on the results of an mysql q

Displaying returned XML in another PHP page
I have an online payment form that will return XML given if a payment is successful or declines. I

problem with php mysql query
Hi guy's...

I'm totally lost here..because don't have any idea how to make a query for grab r

search function
HI guys,

if anyone could point us in the right direction of how to do this, or provide some t

Passing vars to the DB
I have 3 small testing tables:

ID TYPE
1 pepperoni
2 C. bacon
3 taco

ID TY