Update a column of a table with data from another table if columns match PostgreSQL

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;

enter image description here I want to add multiple values to a column if the value in the column matches another value in a column from another table.

e.g.

table1
column1.1
column1.2

table2
column2.1
column2.2

If column2.2 = column1.1 then update column1.2 with column 2.1

Should be able to write multiple values into column 2.1

Here is what I had but it's not working.

SET column1.2 = table2.column2.1
FROM table2
WHERE table1.column1.1 = table2.column2.2

edited Nov 14 '18 at 4:09

asked Nov 14 '18 at 4:01

OSUBuckeyeCompSci

163

Sample data and desire results would really help.

– Gordon Linoff
Nov 14 '18 at 4:03

@GordonLinoff, added picture to see if that helps

– OSUBuckeyeCompSci
Nov 14 '18 at 4:10

add a comment |

enter image description here I want to add multiple values to a column if the value in the column matches another value in a column from another table.

e.g.

table1
column1.1
column1.2

table2
column2.1
column2.2

If column2.2 = column1.1 then update column1.2 with column 2.1

Should be able to write multiple values into column 2.1

Here is what I had but it's not working.

SET column1.2 = table2.column2.1
FROM table2
WHERE table1.column1.1 = table2.column2.2

edited Nov 14 '18 at 4:09

asked Nov 14 '18 at 4:01

OSUBuckeyeCompSci

163

Sample data and desire results would really help.

– Gordon Linoff
Nov 14 '18 at 4:03

@GordonLinoff, added picture to see if that helps

– OSUBuckeyeCompSci
Nov 14 '18 at 4:10

add a comment |

enter image description here I want to add multiple values to a column if the value in the column matches another value in a column from another table.

e.g.

table1
column1.1
column1.2

table2
column2.1
column2.2

If column2.2 = column1.1 then update column1.2 with column 2.1

Should be able to write multiple values into column 2.1

Here is what I had but it's not working.

SET column1.2 = table2.column2.1
FROM table2
WHERE table1.column1.1 = table2.column2.2

edited Nov 14 '18 at 4:09

asked Nov 14 '18 at 4:01

OSUBuckeyeCompSci

163

enter image description here I want to add multiple values to a column if the value in the column matches another value in a column from another table.

e.g.

table1
column1.1
column1.2

table2
column2.1
column2.2

If column2.2 = column1.1 then update column1.2 with column 2.1

Should be able to write multiple values into column 2.1

Here is what I had but it's not working.

SET column1.2 = table2.column2.1
FROM table2
WHERE table1.column1.1 = table2.column2.2

sql postgresql sql-update

edited Nov 14 '18 at 4:09

asked Nov 14 '18 at 4:01

OSUBuckeyeCompSci

163

edited Nov 14 '18 at 4:09

asked Nov 14 '18 at 4:01

OSUBuckeyeCompSci

163

edited Nov 14 '18 at 4:09

asked Nov 14 '18 at 4:01

OSUBuckeyeCompSci

163

asked Nov 14 '18 at 4:01

OSUBuckeyeCompSci

163

asked Nov 14 '18 at 4:01

OSUBuckeyeCompSci

163

Sample data and desire results would really help.

– Gordon Linoff
Nov 14 '18 at 4:03

@GordonLinoff, added picture to see if that helps

– OSUBuckeyeCompSci
Nov 14 '18 at 4:10

add a comment |

Sample data and desire results would really help.

– Gordon Linoff
Nov 14 '18 at 4:03

@GordonLinoff, added picture to see if that helps

– OSUBuckeyeCompSci
Nov 14 '18 at 4:10

Sample data and desire results would really help.

– Gordon Linoff
Nov 14 '18 at 4:03

@GordonLinoff, added picture to see if that helps

– OSUBuckeyeCompSci
Nov 14 '18 at 4:10

add a comment |

2 Answers
2

active

oldest

votes

You seem to want an update from another table. The syntax looks like this:

update table1
 set column1 = table2.column1 
 from table2 
 where table1.column2 = table2.column2;

I can't follow the dance of column names in your question, but this is the structure of updating columns in one table from another table.

answered Nov 14 '18 at 4:04

Gordon Linoff

798k37318423

add a comment |

This should do it -

update table1
 set column1.2 = table1.column1.2 || ' ' || table2.column2.1 
 from table2 
 where table1.column1.1 = table2.column2.2;

answered Nov 14 '18 at 23:16

Mahesh H Viraktamath

4071523

add a comment |

Your Answer

StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);

);

draft saved

draft discarded

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53293025%2fupdate-a-column-of-a-table-with-data-from-another-table-if-columns-match-postgre%23new-answer', 'question_page');

);

Post as a guest

Name

Required, but never shown

2 Answers
2

active

oldest

votes

2 Answers
2

active

oldest

votes

You seem to want an update from another table. The syntax looks like this:

update table1
 set column1 = table2.column1 
 from table2 
 where table1.column2 = table2.column2;

I can't follow the dance of column names in your question, but this is the structure of updating columns in one table from another table.

answered Nov 14 '18 at 4:04

Gordon Linoff

798k37318423

add a comment |

You seem to want an update from another table. The syntax looks like this:

update table1
 set column1 = table2.column1 
 from table2 
 where table1.column2 = table2.column2;

I can't follow the dance of column names in your question, but this is the structure of updating columns in one table from another table.

answered Nov 14 '18 at 4:04

Gordon Linoff

798k37318423

add a comment |

You seem to want an update from another table. The syntax looks like this:

update table1
 set column1 = table2.column1 
 from table2 
 where table1.column2 = table2.column2;

I can't follow the dance of column names in your question, but this is the structure of updating columns in one table from another table.

answered Nov 14 '18 at 4:04

Gordon Linoff

798k37318423

You seem to want an update from another table. The syntax looks like this:

update table1
 set column1 = table2.column1 
 from table2 
 where table1.column2 = table2.column2;

I can't follow the dance of column names in your question, but this is the structure of updating columns in one table from another table.

answered Nov 14 '18 at 4:04

Gordon Linoff

798k37318423

answered Nov 14 '18 at 4:04

Gordon Linoff

798k37318423

answered Nov 14 '18 at 4:04

Gordon Linoff

798k37318423

answered Nov 14 '18 at 4:04

Gordon Linoff

798k37318423

add a comment |

This should do it -

update table1
 set column1.2 = table1.column1.2 || ' ' || table2.column2.1 
 from table2 
 where table1.column1.1 = table2.column2.2;

answered Nov 14 '18 at 23:16

Mahesh H Viraktamath

4071523

add a comment |

This should do it -

update table1
 set column1.2 = table1.column1.2 || ' ' || table2.column2.1 
 from table2 
 where table1.column1.1 = table2.column2.2;

answered Nov 14 '18 at 23:16

Mahesh H Viraktamath

4071523

add a comment |

This should do it -

update table1
 set column1.2 = table1.column1.2 || ' ' || table2.column2.1 
 from table2 
 where table1.column1.1 = table2.column2.2;

answered Nov 14 '18 at 23:16

Mahesh H Viraktamath

4071523

This should do it -

update table1
 set column1.2 = table1.column1.2 || ' ' || table2.column2.1 
 from table2 
 where table1.column1.1 = table2.column2.2;

answered Nov 14 '18 at 23:16

Mahesh H Viraktamath

4071523

answered Nov 14 '18 at 23:16

Mahesh H Viraktamath

4071523

answered Nov 14 '18 at 23:16

Mahesh H Viraktamath

4071523

answered Nov 14 '18 at 23:16

Mahesh H Viraktamath

4071523

add a comment |

draft saved

draft discarded

Thanks for contributing an answer to Stack Overflow!

Please be sure to answer the question. Provide details and share your research!

But avoid …

Asking for help, clarification, or responding to other answers.

Making statements based on opinion; back them up with references or personal experience.

To learn more, see our tips on writing great answers.

draft saved

draft discarded

Post as a guest

Name

Required, but never shown

Name

Required, but never shown

Name

Required, but never shown

This page is only for reference, If you need detailed information, please check here

搜尋此網誌

Dfyjkt