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