...

View Full Version : rundate problem



yyy
02-04-2007, 12:26 PM
Hi, :cool:

I'm writing this query:

SELECT REASON_CODE
FROM REASON
WHERE
to_char(rundate,'MM/YYYY')
BETWEEN to_char(effective_from_date,'MM/YYYY')
AND to_char(effective_to_date,'MM/YYYY')

It gives me the error:
"RUNDATE": invalid identifier

Does someone knows what's the problem??? :confused:



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum