I have a query which runs in the Production DB and not in Development. I won't mind if it does nto return data but it says"Missing expression". I am quiet confused with this. This query was written by some one else and I do not understand the way it is written. - It contains a count(*) as a inside query,
The query is:
select g.GENERIC_NAMEID, g.GENERIC_NAME, g.GENERIC_LABEL, tc.TAGCATID, tc.TAGCATEGORY, a.APPLICATION from GENERIC_NAME g, TAGCATEGORY tc, APPLICATION a WHERE tc.NOT_VISIBLE <> '1' and tc.TAGCATID is not NULL and tc.APPLICATIONID = a.APPLICATIONID and g.TAGCATID = tc.TAGCATID and (select count(*) from tasks where writeback_flag = 'Y' and tasks.generic_name_id = g.generic_nameid) > 0 order by tc.SORTORDER, g.GENERIC_NAME
Would really appreciate if any one could throw light on this.