Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2017

    Unanswered: Match Columns and replace in SQL

    Can someone please help me out with the following issue?

    i would like to match the column ID from the table accounts with column account_id from the table accounts_contacts
    And then replace it with the name on the same row of the matched ID

    In the attachment you can see what i mean


    Click image for larger version. 

Name:	Sjoerdinho.png 
Views:	1 
Size:	2.22 MB 
ID:	17432

  2. #2
    Join Date
    Oct 2007
    Provided Answers: 9
    great. What have you so far written? We can give you some tips on how to correct it, if its not giving you exactly what you need.

  3. #3
    Join Date
    Oct 2017

    Answer For match column

    You can store 'ID' as a foreign key ,then it will map other id which should be unique or Primary key.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts