| View HLPDTEST.STATEGPS.V_NATIVE_TASK_MANAGER_COMMENTS | Generated by SchemaSpy |
| |||||||||||||||||||||||||||||
Analyzed at Mon May 23 01:05 IST 2022 | |||||||||||||||||||||||||||||
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:
|