Without a clearer description of what it isn't doing, my WAG is missing permissions on the views or tables.
Jerry Whittle
ACIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145
-----Original Message-----
From: Seema Singh [SMTP:[EMAIL PROTECTED]]
Hi
Can some one suggest whats wrong in this query?The same query run fine on
development db but not running on production?
select count(a.xxx_id)
from gorp_cats_stats_view a ,
static_pages b
where b.xxx_id = a.xxx_id
and b.words like '%test%'
and a.main not like '%test%'
and a.url not like '%test%'
order by a.url
Thx
-Seema