Skip to Content
0
Former Member
Aug 05, 2016 at 09:15 AM

need a query to update rows from the same table!

23 Views

Hi,

I need for my report a query as follows:

I have only 1 table A

I have many groups of 2 transactions each with the same Reference in the field Reference

I have 2 legs (transaction side) always so I know leg 1 has value 1 in the Leg field and Leg 2 is 2

In the leg 1 I miss one information that exists in leg2 (the date)

So I want to update groups of transactions based on References and get the date from 1 transaction = Leg1 and send it to the second transaction of leg2 based on those details.

Please provide the query it's quite urgent!

thank you so much