Can any one help me writing a user based query ?
i want to retrieve a particular G/L account to a field.
the field must display G/L acc. corresponding to Logged in user.
for example AccCode = 100000 , when manager is logged in.
AccCode = 200000, when some other user logged in.
i tried writing a query in case of manager logged in,
but the same is reflected in case of other login also.
needed a conditional query like when manager is logged in, the field must show only the corresponding code specified for it.
plz help me...(Weak in SQL knowledge)
thks in Advance!
dhana.