Clay Icon

How to Combine Two Existing Tables into One in SQL

ยท
ยท

hello - does anyone know how to combine 2 existing tables into 1? without having to recreate an entirely new table

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    ๐Ÿ‘‹ Hey there! Our support team has got your message - we'll be back in touch within 24 hours (often sooner!). If you haven't already, please include the URL of your table in this thread so that we can help you as quickly as possible!

  • Avatar of Arturo O.
    Arturo O.
    ยท
    ยท

    Hey Rachel, just noticed this is a duplicate thread but sharing my reply here in case you see it first. Thanks for the inquiry and great question! The best way to combine to tables currently is to download the data you'd like to keep/have from one of them as a CSV then upload into the other table. (To prevent enrichments from running you can turn your table auto-update setting off, if needed) I have this video explaining another method and few considerations if it helps. Let me know if you have additional questions!

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    We haven't heard back from you in a bit, so we're going to go ahead and close things out here - feel free to let us know if you still need something!

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    Hi Rachel C.! This thread was recently closed by our Support team. If you have a moment, please share your feedback:

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    Thank you so much for sharing your feedback Rachel C.!