| Working with graph using three parameter [message #210053] |
Tue, 19 December 2006 02:48  |
|
|
select count(empid) ,VCHARDEPT_NAME,VCHARDESIgNAME from department d,
department_section ds,designation de ,assignments a where de.desig_id=a.desig_id and
d.department_id_pk=ds.department_id_pk and ds.dept_sec_id=a.dept_sec_id
group by vchardept_name,vchardesigname
The above query will display total no of employees with there designation and department
But this graph is very complicated
please describe the formating so that its look good
|
|
|
|
|
|
| Re: Working with graph using three parameter [message #210903 is a reply to message #210053] |
Sat, 23 December 2006 01:40  |
|
|
the detail for all tabel the given below
department table contains vchardept_name and department_id_pk
department_section contains dept_sec_id , department_id_pk ,SECTION_ID_PK
designation contains DESIG_ID ,VCHARDESIGNAME
Assignments contains ASSIGNMENT_ID_PK,DESIG_ID,DEPT_SEC_ID
the query is
select count(empid) ,VCHARDEPT_NAME,VCHARDESIgNAME from department d,
department_section ds,designation de ,assignments a where de.desig_id=a.desig_id and
d.department_id_pk=ds.department_id_pk and ds.dept_sec_id=a.dept_sec_id
group by vchardept_name,vchardesigname
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
