i am trying something in mysql but can't remember any sql. Say i have a field called name in table 1 and i want to select the name and the number of times that name appears in the table, how would i do it? If u can tell me, i can find the equiv syntax in mysql thanks. --=20 -------------------------------------------- Tam McLaughlin IT Systems Administrator Scottish Legal Life Assurance Society Ltd