Hi... I have a table where I log every "search" entered into my site, and I = enter every match returned, Searches had LogType 1 and results have logtype = 2... And a field called GroupIdentifier links several results to one = search... How can I get a number of "searched" without responses? It is basically, how many unique GroupIdentifiers with LogType 1 exist, which do not have any equivalent LogType 2 entries... the table is: Name: UniqueLog Fields: LogType GroupIdentifier (Theere are others but these are the ones concerned).. Thanks for any/all help! Cheers, Roy Nasser PS: plsease send copy of responses to my personal e-mail (reply all) Having trouble posting this msg!!!! therefore, sql --------------------------------------------------------------------- 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