Forum Discussion

Rajat's avatar
Rajat
Frequent Visitor
10 years ago

Retrive a value from multiple matching records

  Project Master                                                                                         Task Allocation   ProjectID  projectName  Project Status                                   ...
RakeshP's avatar
RakeshP
Helper I
10 years ago

SELECT PM.ProjectID, PM.projectName,
CASE WHEN T.ProjectID IS NULL THEN 'Completed' ELSE 'In progress' END as ProjectStatus
FROM Project_Master PM,
(SELECT distinct ProjectiD
from task_allocation
where Task_status = 'In progress') t
WHERE pm.ProjectID = t.ProjectiD(+)