Hello can anyone help me with this, i have a table, like the one below, i need to find the time difference between the Start and Stop from a particular CallingStationId to particular CalledStationId.
+------------+----------+--------------------+-------------------+---------- --------+-------------------+ | Date | Time | CallingStationId | CalledStationId | AcctStatusType | AcctSessionTime | +------------+----------+--------------------+-------------------+---------- --------+-------------------+ | 09/01/2004 | 17:28:27 | 02327125 | 00018151635 | Start | | | 09/01/2004 | 19:00:34 | 02320176 | 01181471822125 | Start | | | 09/01/2004 | 19:10:08 | 17113080 | 01022586815 | Start | | 09/01/2004 | 20:28:27 | 02327125 | 00018151635 | Sop | | | 09/01/2004 | 21:00:34 | 02320176 | 01181471822125 | Stop | | | 09/01/2004 | 22:10:08 | 17113080 | 01022586815 | Stop | | Thanking you all in advance. Karma -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
