• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 712
  • Last Modified:

Informix SQL - update a field value string with a data from another table

I need to UPDATE a table field with a data value from another table

Temp Table4
PID   Date
-----------------------
123   23/12/1990
145   14/3/2011

Table1
PID   NOTES
--------------------
123  
145

in Table1 I need the informix code to UPDATE it based on the matching PID in temp table 4
e.g. Table1 should look like this:

can anyone please tell me the code?

Table1
PID   NOTES
--------------------
123   Date was blank is 23/12/1990
145   Date was blank is 14/3/2011
0
JCTDD
Asked:
JCTDD
1 Solution
 
jhp333Commented:
update table1
set notes = (select 'Date was blank is ' || date from table4 where table4.pid = table1.pid)
;
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Network Scalability - Handle Complex Environments

Monitor your entire network from a single platform. Free 30 Day Trial Now!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now