Thanks a lot. It worked fine. But I was able to fetch one component.
I wrote the query to fetch from tabsalarydetail.amount as Basic where salary_component = Basic and that got me the basic of the employees.
I selected employee name also from tabsalary slip and join the two tables by tabsalary slip.name = tabsalary detail.parent.
What am looking for is to write the query to show me all the component or select one or more component with their respective amount against each employee.
How do I get to fetch this data please.