query problem

> > The following query not working. any guidance

> please

> > thanks

> > select unique emonth,e_id from event_time

> > where emonth >= (select to_char(sysdate,'Month')

> from

> > dual)

>

> yup! BalusC is right, please also post the

> database/JDBC vendor/type/version used :-)

> i just assumed your using oracle because of "unique"

> "dual" and "sysdate" you used on your query :-) thank

> you.

>

> regards,

Its throwing logical errors i.e. working but not right

thanks again

farakha at 2007-7-11 23:46:08 >