I have the following query:<BR><BR><BR>mysql= "SELECT count(classcode) as PageCount, Classcode as BusinessCategory FROM Clients,classes WHERE classes.KWord like '%"& searchtext &"%' and clients.categoryID = classes.catcode GROUP BY clients.classcode"<BR><BR>Basically I want to link 2 tables. One table has the keywords and the other has the results from which the corresponding keywords match. Thereafter I want to group the results according to some other field in the clients database. <BR>I came up with the above code which is not working. I keep getting the error that the parameters are too few. Is there a better way of building this query or what could be the problem?