Juha,
select dep.Ref, dep.ActionDate as Departure, arr.ActionDate as Arrival,
dlv.ActionDate as Delivery
from
Table1 dep left join Table1 arr on (dep.Ref = arr.Ref and arr.Timestamp =
'ARR')
left join Table1 dlv on (dep.Ref = dlv.Ref and
dlv.Timestamp = 'DLV')
where
dep.Ref = arr.Ref
and dep.Timestamp = 'DEP'
Best regards,
Mikhail.
----- Original Message -----
From: "Morsky Juha" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, September 26, 2002 10:06 AM
Subject: Update problem in MySQL
> Do anyone has a idea how to Insert (create SQLQuery) from onetable to an
> other table as
> decripted under:
>
> Here is the orginal Table:
>
> Table1:
> --------------------------------------------
> Ref | Timestamp | ActionDate
> -------+-----------------+----------------
> 001 | DEP + 2002/01/02
> -------+-----------------+----------------
> 001 | ARR + 2002/01/04
> -------+-----------------+----------------
> 001 | DLV + 2002/01/15
> -------+-----------------+----------------
> 002 | ARR + 2002/02/02
> -------+-----------------+----------------
> 002 | DEP + 2002/02/03
> -------+-----------------+----------------
> 002 | DLV + 2002/02/18
> -------+-----------------+----------------
> 003 | DEP + 2002/01/12
> -------+-----------------+----------------
> 003 | ARR + 2002/01/14
> -------+-----------------+----------------
> 003 | DLV + 2002/01/25
>
>
> I should update Table one to Table2, which means that insted of 9 rows I
> should have row per "Ref"
>
> Table2:
> ----------------------------------------------------------------
> Ref | Departure | Arrival | Delivery
> -------+-----------------+------------------+----------------
> 001 | 2002/01/02 + 2002/01/04 | 2002/01/15
> -------+-----------------+------------------+----------------
> 002 | 2002/02/02 + 2002/02/03 | 2002/02/18
> -------+-----------------+------------------+----------------
> 003 | 2002/01/12 + 2002/01/14 | 2002/01/25
> -------+-----------------+------------------+----------------
>
> Thanks for your help
> Juha
>
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
