need to read data from oracle database with many conditions
- by randeepsp
hi!
i have 3 tables A,B and C.
table A has column employee_name,id
table B is the main table and has columns id,os version.
table c has the columns id,package id and package version.
i want to query the count of employee_name where the id of table a and c are matched with id of table b(which is the main table).
i should also get the names of employees grouped by the os version they have and also the package version.