Removing semicolon data containing in 3 columns arrange in 3 row data

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Oracle227
    New Member
    • Jul 2015
    • 1

    Removing semicolon data containing in 3 columns arrange in 3 row data

    I had 2 tables 1st ABC table i had 5 columns,2nd table by name EFG had 5 columns.
    data is
    1st table ABC
    a b c d e
    - - - - -
    1;2;2;3 5;6 ag lm12 string
    1,2,5 8;6 ef lki23 aaa

    update in table EFG by comparing in above table
    a b c d e
    - - - - -
    1 6 ef update update
    3 8 ag " "
Working...