Skip to Content
avatar image
Former Member

Crystal update a cell from another based on transactions having same ID

ID | Col1 | Col2 | Col3|ColX

------------------------
A  |10|12345| S | |
C  |20|12345| L | |
D  |40|67890| S | |
E  |30|67890| L | |
Hi, I need an sql command to use in crystal reports that updates COlX from Col1 from a transaction that have Col3 = S to a transaction with Col3= L if Col2 values are the same. the result would be in this example:
ID | Col1 | Col2 | Col3|ColX
------------------------
A  |10|12345| S | |
C  |20|12345| L |10|
D  |40|67890| S | |
E  |30|67890| L |40|
Many thanks



Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers