[EMAIL PROTECTED] wrote:
The actual situation is a telecom analysis: a calls b and a is suspect. Who are the people connected to a ? we have call records of calls in tables
Ok, so you should have a table, I presume, like: Callers: id (phone number) Calls: id, callerid, calledid, startime, endtime SELECT calledid FROM Calls WHERE callerid = suspect; SELECT callerid FROM Calls WHERE calledid = suspect; SQL. (you could put them both in one result list as well) -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock --------------------------------------------------------------------- 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