469,325 Members | 1,578 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,325 developers. It's quick & easy.

Informix : update syntax using a field name

I use Informix SQL.
I have 2 tables, each with a reference and a status.
I would like to update the table 1 status with the value of table 2's status, but do not know the syntax.
I have tried something like :-
Expand|Select|Wrap|Line Numbers
  1.   update t1
  2.   set t1.status = t2.status
  3.   where t1.reference in (select reference from t2)
  4.  
but get t2 not declared.
Any assistance will be most gratefully received !
Feb 16 '11 #1
0 1212

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

3 posts views Thread by Tony | last post: by
5 posts views Thread by David | last post: by
6 posts views Thread by Matt | last post: by
2 posts views Thread by WU | last post: by
reply views Thread by NerdRunner | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
reply views Thread by listenups61195 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.