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