Need SQL to extract the amount and periodicity of worker element entries
Summary:
Hi Experts,
Could you please provide SQL code that extracts the amount and periodicity of worker element entries? I need help with this requirement.
Written this but it's giving me Amount not Periodicty, Really appreciate your help in Advance.
select pivf.*,
(SELECT pivf.RESERVED_INPUT_VALUE
FROM pay_element_entries_f peef
,pay_element_types_f petf
,pay_input_values_f pivf
,pay_element_entry_values_f peevf
,per_all_people_f per1
WHERE peef.element_type_id = petf.element_type_id
AND petf.element_type_id = pivf.element_type_id
AND peef.element_entry_id = peevf.element_entry_id