|
|
|
|
| Re: View gross salary on section wise [message #651738 is a reply to message #651737] |
Tue, 24 May 2016 04:13   |
John Watson
Messages: 8960
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
Your refusal to write any SQL yourself shows extreme laziness. You also refuse to answer requests such as showing the query behind that report. Showing industry in creating new topics does not disguise this.
Generally, you give the impression of being a lazy sloth who does not deserve assistance. Perhaps other people will disagree.
[Updated on: Tue, 24 May 2016 04:15] Report message to a moderator |
|
|
|
| Re: View gross salary on section wise [message #651742 is a reply to message #651738] |
Tue, 24 May 2016 05:00 |
 |
Salehin
Messages: 62
Registered: March 2013
Location: Chittagong, Bangladesh
|
Member |
|
|
Sorry dont misunderstand I thought if i share it in reports section that will help me because barbara said to me that she had nothing to open my rdf file.
here is my sql code
select ep.empno, ep.b_name, ep.card_no,ep.first_name||' ' ||ep.middle_name||' '||ep.last_name ename,
ep.religion_name, em.des_name,ep.age, em.N_GROSS_HLP , eo.section_name,eo.joining_date, em.grade,eo.floor_desc
from emp_personal ep, emp_official eo, emp_payment em
where ep.empno = eo.empno
and ep.empno = em.empno(+)
--and eo.section_name = 'Sewing'
and eo.joining_date between '1-APR-2015' and '30-APR-2015'
--and ((eo.joining_date between '1-may-2014' and '31-may-2014') or (eo.joining_date between '1-may-2015' and '31-may-2015'))
and ep.status = 'Active'
and eo.ot_ent = 'Yes'
--and em.grade between '3' and '6'
--and eo.floor_desc=:floor
and eo.company_name = :unit
order by ep.empno
[Updated on: Tue, 24 May 2016 05:03] Report message to a moderator |
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
