Can you post a list of the results?
Riva
On 12/18/2008 8:10 AM, Matthew Macdonald-Wallace wrote:
Hi All,
Can someone please explain why the following query returns a number of
search results for each article instead of a single copy of each
article that matches?
SELECT DISTINCT resources.resourceId,
resourceTitle,
extract,
iconPath,
iconName,
resourceTypes.resourceTypeId,
resources.resourceTypeId
FROM resources,
icons,
resourceTypes,
categories,
resource2category
WHERE icons.iconId = resourceTypes.resourceTypeIconId
AND resources.resourceTypeId = resourceTypes.resourceTypeId
AND categories.categoryId = resource2category.categoryId
AND resources.resourceId = resource2category.resourceId
AND resourceTitle LIKE "%legal%"
OR keywords LIKE "%legal%"
OR extract LIKE "%legal%"
OR resourceTitle LIKE "%waste%"
OR keywords LIKE "%waste%"
OR extract LIKE "%waste%"
AND resourceIsActive = '1'
ORDER BY resourceTitle DESC
Thanks,
Matt
____ The WDVL Discussion List from WDVL.COM ____
To Join wdvltalk, Send An Email To:
mailto:[email protected] or
use the web interface http://e-newsletters.internet.com/discussionlists.html/
Send Your Posts To: [email protected]
To change subscription settings, add a password or view the web interface:
http://intm-dl.sparklist.com/read/?forum=wdvltalk
________________ http://www.wdvl.com _______________________
You are currently subscribed to wdvltalk as: [email protected]
To unsubscribe send a blank email to
leave-50161448-230552.f22dcf5120bad5a91a87f69f1e923...@lists.wdvl.com
To unsubscribe via postal mail, please contact us at:
Jupitermedia Corp.
Attn: Discussion List Management
475 Park Avenue South
New York, NY 10016
Please include the email address which you have been contacted with.
