View HLPDTEST.STATEGPS.V_NATIVE_TASK_MANAGER_COMMENTS | Generated by SchemaSpy |
| |||||||||||||||||||||||||||||
Analyzed at Sun Jan 17 01:06 IST 2021 |
View Definition:
select pt.project_task_id,(
select tmc1.comments from t_task_manager_comment tmc1
where pt.project_task_id = tmc1.project_task_id
and tmc1.comment_id = (
select max(tmc.comment_id) from t_task_manager_comment tmc
where pt.project_task_id = tmc.project_task_id
and tmc.comments is not null
)) manager_comments
from t_project_task pt
Possibly Referenced Tables/Views:
![]() ![]() |