09-29-2008 8:15 AM
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.
09-29-2008 8:17 AM
09-29-2008 8:18 AM
>
> 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