I need to update a column in a table based on value of the same column in another table.

I have a key column as well.

Answers

  • Can you share two simplified tables with a bunch of rows each?
    It would make it much easier for us to show you how to do that.

    Also - do you need to do that once - or every time you get new data to add? The approach would be different.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.