SELECT Query

Former Member — Mon, 27 Jun 2011 07:40:24 GMT

Hello all,

I am trying to select a list of leavers from our HR system :

 
  SELECT * 
    FROM pa0000 
   WHERE aedtm > begda         " Backdated leavers 
     AND massn = '54'.         " Leaver

I want to select people where the date entered on the system i.e. AEDTM

is greater than the actual leave date.

However, typing in the code above gives me the error

'Field "BEGDA" is unknown. It is neither in one of the specified tables'

I guess it is expecting a user defined variable instead of another database

column name.

Does anybody know how I can around this??

i.e. compare one database field against another one

Many thanks

Andy

Re: SELECT Query

former_member182670 — Mon, 27 Jun 2011 07:45:45 GMT

WHERE pa0000~aedtm > pa0000~begda

Former Member — Mon, 27 Jun 2011 07:47:40 GMT

doh !!!!

Thanks Tomek, uch appreciated