> ... could my problem be more than the query? sure, but let's get the query working correctly first yes, you should do an inner join how are the city and category tables related? rudy