Skip to Content
0

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

Jan 30 at 01:07 PM

8

avatar image
Former Member

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



10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers