[SPTUsers] SQL Data Call

[Wakefield, Beth USA Contractor]

I'm trying to call some data out of SPT with a SQL statement like this
one, I want data where ControlledNameId=100 AND 103 not OR. This seems
to be the problem. 

SELECT Resources.Title, Resources.URL, Resources.Description
FROM ResourceNameInts INNER JOIN Resources ON
ResourceNameInts.ResourceId = Resources.ResourceId
WHERE (ResourceNameInts.ControlledNameId= '100') AND
(ResourceNameInts.ControlledNameId='103')

I also tried this: with no luck. 

SELECT Resources.Title, Resources.URL, Resources.Description
FROM ResourceNameInts INNER JOIN Resources ON
ResourceNameInts.ResourceId = Resources.ResourceId
WHERE ResourceNameInts.ControlledNameId 
IN('100', '103')
GROUP BY ResourceId
Having Count(ResourceId)=2

If someone can please help me with this query it would be greatly
appreciated! Thanks in advance.

Beth
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://scout.wisc.edu/pipermail/sptusers/attachments/20030827/73851ccb/attachment.htm