subject:"help on SQL JOIN"

Re: help on SQL JOIN

2006-06-02 Thread Peter Brawley

Nhadie, ...what i want to actually achieve is to get only the time of the first INVITE and then it's corresponding BYE so it should look like this +--+--+--+--+--+--+ | username | t1method | t2method | start| stop | timediff | +-

help on SQL JOIN

2006-06-02 Thread Nhadie

Hi All, I have this test table +--+--+--+--++--+ | username | key1 | key2 | key3 | method | timer| +--+--+--+--++--+ | nhadie | aaa | bbb | ccc | INVITE | 00:00:10 | | nhadie | aaa | bbb | ccc | ACK| 00:00:1