I have five tables. Each has a primary key on the field Number. I would like to determine how many tables -- just the count -- that any given $Number populates. Every $Number will populate at least two tables, some possibly all five. I just want a count(*) I appreciate the advice. Robert --------------------------------------------------------------------- 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