"Petter Topp" <petter.topp@atcdata.no> wrote in message
news:D9A112D8-4CC8-4FE2-8288-C20C451C133E@news.elevatesoft.com...
> Could yoiu confirm this before I post a message in the binaries.
>
Sure.

Robert

Thanks Robert, I have made a post in the binaries with the subject "How to
do this part 2".

Regards
Petter Topp


"Robert" <ngsemail2005withoutthis@yahoo.com.ar> skrev i melding
news:10A1D84A-3695-456A-954B-F703A029D6D7@news.elevatesoft.com...
>
> "Petter Topp" <petter.topp@atcdata.no> wrote in message
> news:D9A112D8-4CC8-4FE2-8288-C20C451C133E@news.elevatesoft.com...
>> Could yoiu confirm this before I post a message in the binaries.
>>
> Sure.
>
> Robert
>
>
>

Petter


Try this

select
TRANS_ID,
LOCATION_ID,
IF(CUSTOMER_ID=NULL THEN T2.CUSTOMER_ID ELSE CUSTOMER_ID)
from Translogg
JOIN Translogg T2 ON TRANS_ID=T2.TRANS_ID
where location_id='2' and T2.CUSTOMER_ID <> null
order BY TRANS_ID


Roy Lambert

Thanks Roy,

This worked very nice, and now that I see the solution, all that was needed
was to remove the "empty" records from T2. Brilliant!
Thank you very much Robert and Roy, your help is much appreciated.
I wish there was some way to give you both a cup of coffee and a cake.....

Regards
Petter Topp


"Roy Lambert" <roy.lambert@skynet.co.uk> skrev i melding
news:95481529-158E-4743-8DBB-8275903959D3@news.elevatesoft.com...
> Petter
>
>
> Try this
>
> select
> TRANS_ID,
> LOCATION_ID,
> IF(CUSTOMER_ID=NULL THEN T2.CUSTOMER_ID ELSE CUSTOMER_ID)
> from Translogg
> JOIN Translogg T2 ON TRANS_ID=T2.TRANS_ID
> where location_id='2' and T2.CUSTOMER_ID <> null
> order BY TRANS_ID
>
>
> Roy Lambert
>
>