hi...
plz somone help me write these queries..
i want to search the data's from project
that takes the data from project table
select project-id,projectname,employeename
conditions:
1)search using projectid
2)projectname
3)employee name: the data's sholud be selectd employee's designation should be equal to projectmanager.
constraint: project.empid=employee.empid
desig.desgi_id=employee.desig_id