Foreign key in the column values of another table

  • I have trouble in writing a SQL query.

    I have a data table with below columns.

    DataTable 1

    id        notes

    ----------------------------------------------------------------

    1          develop document disseminate to {{param = "ac-       1_prm_1"}}

    2          develop document to {{param = "ac-1_prm_2"}}

    Data table Parameter

    parameterid  value.       Id

    -------------------------------—————-

    ac-1_prm_1    apple doc.   1

    ac-1_prm_2    google doc.  1

    ac-1_prm_3   facebook doc.  2

    I need create a final_notes column:

    id         notes             final_notes

    ------------------------------------------------------------------

    1      develop document disseminate    develop   document

    to{{param = "ac-1_prm_1"}}       disseminate to

    and {{param = "ac-1_prm_2"}}   apple doc and google

    2 develop document                develop document facebook     {{param = "ac-1_prm_3"}}.    doc

    • This topic was modified 1 month, 2 weeks ago by  teb.
    • This topic was modified 1 month, 2 weeks ago by  teb.
  • Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

  • This was removed by the editor as SPAM

  • This was removed by the editor as SPAM

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply