SELECT Query

[Former Member]

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

[former_member182670]

WHERE pa0000~aedtm > pa0000~begda

[Former Member]

doh !!!!

Thanks Tomek, uch appreciated