[thelist] SQL: Eliminating Duplicates with .getRows()

[rudy]

SELECT sID, sNumber, sTitle, sOshaAnsi, aApp
FROM tblSigns, xrefAppsSigns
WHERE (sTitle LIKE '% s %'
OR aApp LIKE '% s %')
AND sNumber = aNumber
GROUP BY sID, sNumber, sTitle, sOshaAnsi, aApp

count(*)?  wouldn't that just show how many categories the sign is in?

hey ken, if you get a hit on a category, do you really want to return all
the signs in that category?

you know, if i were a user, that might be too much unrelated stuff for
me...

rudy