Foreign key in the column values of another table

• teb

  SSC Enthusiast

  Points: 187

  More actions

  December 4, 2021 at 12:53 pm

  #3960276

  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 2 years, 4 months ago by  teb.
  • This topic was modified 2 years, 4 months ago by  teb.

• Site Owners

  SSC Guru

  Points: 80320

  More actions

  December 5, 2021 at 1:10 pm

  #3960567

  Thanks for posting your issue and hopefully someone will answer soon.

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

• December 6, 2021 at 7:26 am

  This was removed by the editor as SPAM

• December 20, 2021 at 6:05 am

  This was removed by the editor as SPAM