order id is changing
Posted: Tue Jul 27, 2004 9:09 am
hi,
can u please guide me
i have in my source order id previous_orderid original_order_id
51411 - -
51428 51411 51411
51432 51411 51411
this record comes as 1 record i want my curr_flg be 1 on last order id thats 51432
please guide me i am in fix do i have to write some kind of subquery
Thanxs
bobby
can u please guide me
i have in my source order id previous_orderid original_order_id
51411 - -
51428 51411 51411
51432 51411 51411
this record comes as 1 record i want my curr_flg be 1 on last order id thats 51432
please guide me i am in fix do i have to write some kind of subquery
Thanxs
bobby