topic select query in Application Development and Automation Discussions

select query

Former Member — Mon, 29 Sep 2008 07:15:12 GMT

hi,

i need select query where personal no and payroll are the inputs . By which i should get the wage type of those employees where wage typr is hard coded . Wage type should be taken from RT table (cluster table).

Please resolve my query as soon as possible.

Re: select query

Former Member — Mon, 29 Sep 2008 07:17:43 GMT

Hi,

i think you shell try it as soon as possible.

Regards, Dieter

Re: select query

Former Member — Mon, 29 Sep 2008 07:18:42 GMT


> hi,
> i need select query where personal no and payroll are the inputs . By which i should get the wage type of those employees where wage typr is hard coded . Wage type should be taken from RT table (cluster table).
> Please resolve my query as soon as possible.

Hi,

select wage type from rt table where

employee no = ...

and payroll =

and wage typr = 'Hard code data in caps'.

Hope it will be helpful

Regards,

Srinivas